SQLite Table Exists

[Mike Bonner]

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 <bonnmike at 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.heaford at 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 at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
>