Getting values out of DataGrid

[eddje16]

Hello,

I have problems getting values out of a Datagrid.

I have this simple DataGrid

col1 col2
Club Plaats (=column title)
DOVO Assen
Roda Raalte
ACV Assen

Now I want to get the bold values based on the Plaats = Assen.

I already have this code, but than I only get the first value, not both values.


put text of field "resultpost" into tNaam2

repeat for each line theLine in theData
dispatch "FindIndex" to group "tabel" with "plaats", tNaam2
end repeat

put the result into theIndex
put the dgDataOfLine[theIndex] of group "tabel" into theMessageB
put theMessageB["club"] into pZoekenoppostcode
put pZoekenoppostcode into field "post"

Can someone help me out?

[Klaus]

Dag Ed,

what you see on the monitor, the datagrid, is only the visual representation of the actual data, which you need to search!
"FindIndex" will always only find one entry.

Do this:

Code: Select all

...
## This is what you are looking for, right?
put text of field "resultpost" into tNaam2

## Get the actual data
put the dgdata of grp "tabel" into tData

## Now loop through all KEYS of this array and check them:
repeat for each key tKey in tData
   if tData[tKey]["plaats"] = tNaam2 then

     ## Collect desired values:
     put tData[tKey]["club"] & CR after tListOfFoundValues
   end if
end repeat

## Delete trailing CR
delete char -1 of tListOfFoundValues
put tListOfFoundValues into fld "post"
...

Groetjes

Klaus

[eddje16]

Thank Klaus,

That worked great.

You make it look so easy!

[Klaus]

Grag gedaan

A day too late, but anyway:
Sinterklaas Kapoentje
Doe iets in mijn schoentje
Doe iets in mijn laarsje
Dank U Sinterklaasje!

[eddje16]

Haha!

I got from Sinterklaas new socks with my name on it, how cool is that?

[Klaus]

That is VERY cool!

[eddje16]

Man, I'm so happy with it!

I don't really want to make another post, but I still have one problem with my stack. Everytime I open it, it is focussing on the first field. I already put some "focus on nothing" in it but nothing seems to work.

Can you have a look at it:

www dropbox com / s / m839lf68tolvi44 / VoetbalNavi1 . 6 . livecode

[Klaus]

Hi Ed,

Man, I'm so happy with it!

yes, I understand that, socks with your name on them IS definitively cool!

To your problem, add this to the "opencard" or "openstack" script:

Code: Select all

on openCard
  send "focus on nothing" to me in 5 millisecs
end openCard

Play a bit with the time until it works for you...

This is neccessary, since you cannot "turn off" the default behavior of Livecode,
which IS to focus on the first field on a card everytime you go to that card.


Best

Klaus

[eddje16]

I know!

Jealous?

Your solution worked.....of course..

Next problem is with GPS. It won't work on my Android device.

try
mobileStartTrackingSensor "location", true
put mobileSensorReading("location", true) into tLocation
mobileStopTrackingSensor "location"
set the itemdelimiter to comma
if the number of items in tLocation = 3 then
put item 1 of tLocation into pLat
put item 2 of tLocation into pLon
end if

end try



Is it the device itself or the code?

[Klaus]

Hi Ed,

Jealous?

A bit!

Next problem is with GPS. It won't work on my Android device.

Code: Select all

...
try
      mobileStartTrackingSensor "location", true
      put mobileSensorReading("location", true) into tLocation
      mobileStopTrackingSensor "location"
      set the itemdelimiter to comma
      if the number of items in tLocation = 3 then
         put item 1 of tLocation into pLat
         put item 2 of tLocation into pLon
      end if    
   end try
...

Is it the device itself or the code?

Hm, since I do not develop for mobile I can only guess.
Did you check if the device has a "sensor" with "mobileSensorAvailable"?


Best

Klaus

[eddje16]

Thought so!

Yes, the sensor is available, I checked it.

[Klaus]

Ah, OK.

Maybe you should post your question right to the ANDROID forum (Hint, Hint!)