Probably the easiest way is a select: put "select * from tablename" into tSql revexecutesql tDbId,tSql
if the result contains "no such table tablename" its not there. On Tue, May 5, 2015 at 2:23 AM, Terence Heaford <t.heaf...@icloud.com> wrote: > Is there a LC function for checking if a table exists in an sqlite > database or do I have to do something like this? > > > function doesTableExist tTableName > put replaceText(tTableName,"'","''") into tTableName > put merge(“SELECT count() FROM sqlite_master WHERE type = 'table' AND > name= '[[tTableName]]'") into tSQL > put revDataFromQuery(tab, return, myDB, tSQL) into tCount > if tCount = 1 then > return true > else > return false > end if > end doesTableExist > > > All the best > > > Terry > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
