hair-pulling frustration

Dr. Hawkins dochawk at gmail.com
Thu Nov 13 14:09:56 EST 2014


On Wed, Nov 12, 2014 at 11:22 AM, Peter Haworth <pete at lcsql.com> wrote:

> On Tue, Nov 11, 2014 at 3:13 PM, Dr. Hawkins <dochawk at gmail.com> wrote:
>
> > "SELECT * FROM sometable;"  worked before the change with SQLite.  Now,
> it
> > is necessary to remove the semicolon.
> >
>
> I just tried this using LC 5.5.4 (prior to the SQLite library change) and
> LC 6.6.2 (after the SQLite library change), with and without the semicolon
> and all tests worked fine.
>
> You mentioned a "parsing error" - did you mean an LC compile error or an
> SQLite error?  Either way, what was the error?
>

revDataFromQuery(,,17,"SELECT * FROM vader_darth______001_dna;")
yields
Message execution error:
Error description: value: error executing expression
Hint: ")

While if I leave out the semicolon, it gives me all the data in the table.

This from 7.0-RC2 moments ago
-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462



More information about the use-livecode mailing list