What do you get in theRes when it works? CREATE shouldn't return any data. I always use revExecuteSQL for any SQL statement other than SELECT, although if revDataFromQuery works in the IDE it should work in the standalone.
Pete lcSQL Software On May 23, 2014 11:33 PM, "Dr. Hawkins" <doch...@gmail.com> wrote: > This section of code has worked for quite some time. Now, it's failing in > standalones, but works just fine in the ide. > > I already have an in-memory SQLite database open at cacheDb. The ck > command just puts to the message box and after a log window. > > dcmd is shown as > dcmd: CREATE TABLE clientNameRemoved_001_dinfo (kywd VARCHAR(20), dTyp > CHAR(1), usr VARCHAR(20), tstmp TEXT, val TEXT, dfl TEXT, dvl INTEGER, > ddf INTEGER, dta TEXT, ch BOOLEAN, UNIQUE(kywd) ) ; > > For the code > ck "dcmd: " & dcmd > put revDataFromQuery(,,cacheDb,dcmd) into theRes > answer "theRes:" & theRes > > I get to the answer in the IDE, with a table created successfully. > > In a standalone, though, the answer command is not reached, and the handler > exits silently. > > > > -- > Dr. Richard E. Hawkins, Esq. > (702) 508-8462 > _______________________________________________ > 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