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 <[email protected]> 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 <[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 _______________________________________________ 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
