SQLite DOT functions

[Terence Heaford]

Thanks Mike,

I thought maybe I’d missed a built in function for this.

All the best

Terry


> On 25 May 2015, at 20:18, Mike Bonner <bonnmike at gmail.com> wrote:
> 
> get revdatafromquery(,,sDatabaseId,"select  sql  from sqlite_master where
> name='COMPANY'")
> 
> This will return the SQL to create the table as a row of returned data.
> 
> 
> SDatabaseId is of course the database connection id.
> 
> 
> On Mon, May 25, 2015 at 12:45 PM, Terence Heaford <t.heaford at icloud.com>
> wrote:
> 
>> How do you implement the following DOT function in LiveCode
>> 
>> sqlite>.schema COMPANY
>> 
>> 
>> CREATE TABLE COMPANY(
>>   ID INT PRIMARY KEY     NOT NULL,
>>   NAME           TEXT    NOT NULL,
>>   AGE            INT     NOT NULL,
>>   ADDRESS        CHAR(50),
>>   SALARY         REAL
>> );
>> 
>> 
>> 
>> Thanks
>> 
>> 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
>> 
> _______________________________________________
> 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