Yeah, I think the dot functions are specific to the interactive client, but i'm not positive. Either way, it works well.
On Tue, May 26, 2015 at 12:42 AM, Terence Heaford <t.heaf...@icloud.com> wrote: > 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 <bonnm...@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.heaf...@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
