On Aug 24, 2009, at 10:17 AM, Josep wrote:
I'm try to retrieve all the records from a table named "products"
Hi Josep,
Going forward you may want to post SQL yoga related questions in the
forums I've set up for it:
<http://www.bluemangolearning.com/forums/viewforum.php?id=15>
And from a button I try to populate the datagrid
put sqlquery_create("product") into theQueryA
sqlquery_set theQueryA, "order by", "model"
sqlquery_retrieveAsArray theQueryA, theRegionDataA
put the result into theError
if theError is empty then
## Array can be assigned directly to a data grid
set the dgData of group "dg_test" of me to theRegionDataA
else
answer "Error populating regions:" && theError
end if
But nothing happen or the protected stack appear...
What I'm doing wrong?
What do you see in the message box if you add this to the handler:
## print out MD array with first line of each key value.
put printkeys(theRegionDataA)
--
Trevor DeVore
Blue Mango Learning Systems
ScreenSteps: http://www.screensteps.com
Developer Resources: http://revolution.bluemangolearning.com
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
