SQLite DOT functions

[Mike Bonner]

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
>