silent fail of revDataFromQuery() in standalone; works in IDE
pete at lcsql.com
Sat May 24 04:08:58 EDT 2014
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
On May 23, 2014 11:33 PM, "Dr. Hawkins" <dochawk at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode