SQLite Table Exists

[Terence Heaford]

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