I am working on the sort, search and find in SQL lite with revDataFromQuery in a single database with a single table.
I know this is simple for people who already are able to do it but for those who are new to working with database selecting records here are a couple of steps to help. To return a list of ALL RECORDS with ALL FIELDS in a table named tFiles you can use the following where gConID = the connection id; put "SELECT * FROM tFiles" into tSQL --returns all records & fields put revDataFromQuery(,,gConID,tSQL) into tList put tList To return a list of ALL RECORDS in 1 FIELD in a table named tFiles you can use the following where gConID gConID = the connection id and the field name is FirstName; put "SELECT FirstName FROM tFiles" into tSQL --returns all records in 1 field put revDataFromQuery(,,gConID,tSQL) into tList put tList John Balgenorth _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
