SQLite Table Exists

[Richard Gaskin]

Terence Heaford 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

The example given in the Dictionary entry for the revDatabaseTableNames 
function may do what you need:

    if tTableName is among the lines of \
        revDatabaseTableNames(sgDatabaseId) then
    ...

-- 
  Richard Gaskin
  Fourth World Systems
  Software Design and Development for the Desktop, Mobile, and the Web
  ____________________________________________________________________
  Ambassador at FourthWorld.com                http://www.FourthWorld.com