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 <[email protected]> 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 > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
