oh, and you can add a limit 1 to make it faster. (no sense in selecting a whole tables data)
On Tue, May 5, 2015 at 7:39 AM, Mike Bonner <bonnm...@gmail.com> wrote: > 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
