DataGrid Retrieval Method?
Posted: Sun Sep 27, 2015 5:39 pm
Hello, I am new to datagrids and had a question. I have a MySQL database and I already got the following lesson to work:
I read in the comments that someone uses the revDataFromQuery command, similar to what is found on connecting to a SQLite lesson:
I would like to learn both ways if possible. I am trying to find an example to use the revDataFromQuery method for inserting data in a datagrid table. Is there an example script of this somewhere that I can study.
Thanks
for a datagrid table.
I read in the comments that someone uses the revDataFromQuery command, similar to what is found on connecting to a SQLite lesson:
.
Code: Select all
on mouseUp
put databaseGetContactDetails() into field "contact details"
end mouseUp
and add the databaseGetContactDetails function to the card script
function databaseGetContactDetails
## Query the database for contact details to be displayed in the field
put getDatabaseID() into tDatabaseID
put "SELECT * from contact_details" into tSQL
put revDataFromQuery(tab,return,tDatabaseID,tSQL) into tRecords
return tRecords
end databaseGetContactDetails
Thanks