how can I loop the data from my query.. Help.!

[snop21]

Hello guys,


I just want to ask how can I loop the data from my query? I just want it to display it to the message box instead of displaying into the datagrid.

I attached the file.

Any help will be very much appreciated.

Regards

-snop21

[splash21]

Hi, snop21. Just change;

Code: Select all

set the dgText of group "Datagrid 1" to tdisplay

to

Code: Select all

put tdisplay into msg

and the results will show in the message box

[Klaus]

And that also works nicely on a Mac and Linux

[snop21]

Hi splash21 and Klaus,


Pardon me... ) It's not a message box actually that I want to display it. )

I want to display it with the dialogbox "it's answer here in livecode"

from my query I want to loop to get the record from it and diplsay it to the dialogbox one by one.

repeat ----

answer " " -----> data from my query

end repeat

Don't know how to do it exactly..

Need your help guys..

Regards

-snop21

[splash21]

repeat ----
answer " " -----> data from my query
end repeat

You've already got it!

Code: Select all

repeat for each line tRow in tDisplay
  answer tRow
end repeat