revDataFromQuery Selecting Files

JB sundown at pacifier.com
Thu Mar 26 18:41:39 EDT 2015


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


More information about the Use-livecode mailing list