revOpenDatabase Problem

Andre Garzia andre at andregarzia.com
Mon Dec 26 17:08:39 EST 2011


Pete,

Try the following query:

SELECT name FROM sqlite_master
WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%'
UNION ALL
SELECT name FROM sqlite_temp_master
WHERE type IN ('table','view')
ORDER BY 1

It should return the tables in the database, if there are no tables,
then, there is something wrong.

Cheers
andre



More information about the use-livecode mailing list