Hi Terry, I'm curious as to why you need to do this. If you need to create the table if it doesn't exist, you could CREATE TABLE IF NOT EXISTS.
Pete lcSQL Software On May 5, 2015 1: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
