silent fail of revDataFromQuery() in standalone; works in IDE

Dr. Hawkins dochawk at
Fri May 23 18:33:55 EDT 2014

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

More information about the Use-livecode mailing list