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