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

Peter Haworth pete at
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

lcSQL Software
On May 23, 2014 11:33 PM, "Dr. Hawkins" <dochawk at> 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
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:

More information about the Use-livecode mailing list