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

[Peter Haworth]

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" <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:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>