Page 1 of 1

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

Posted: Thu Feb 20, 2014 10:39 am
by 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

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

Posted: Thu Feb 20, 2014 10:57 am
by 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

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

Posted: Thu Feb 20, 2014 12:54 pm
by Klaus
And that also works nicely on a Mac and Linux 8)

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

Posted: Fri Feb 21, 2014 2:35 am
by 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

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

Posted: Mon Feb 24, 2014 6:15 pm
by splash21
snop21 wrote:repeat ----
answer " " -----> data from my query
end repeat
You've already got it! :P

Code: Select all

repeat for each line tRow in tDisplay
  answer tRow
end repeat