hair-pulling frustration

Peter Haworth pete at lcsql.com
Tue Nov 11 20:49:11 EST 2014


OK, I'll try with and without multiple statements in both versions.

I do want to double check that you're not trying to access an SQLite
database over a network because you WILL have major problems if you are :-)

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Tue, Nov 11, 2014 at 3:13 PM, Dr. Hawkins <dochawk at gmail.com> wrote:

> On Tue, Nov 11, 2014 at 1:09 PM, Peter Haworth <pete at lcsql.com> wrote:
>
> > I rarely, if ever, try to execute multiple SQL statements in one
> > revDatabasexxx so haven't seen that particular problem. Could you give an
> > example? I'd like to check it out as I don't want to get hit by the same
> > bug.
> >
>
> I routinely execute many synchronize with the remote, as latency is a big
> deal and stops the single-threaded livecode.
>
> "SELECT * FROM sometable;"  worked before the change with SQLite.  Now, it
> is necessary to remove the semicolon.
>
> I routinely code the semicolons in because I variously use both direct
> revDatabaseXxxx  calls and my own routine which wraps with Begin/End.  That
> way, I can, err, could, simply write my queries.
>
>
> --
> 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
>



More information about the use-livecode mailing list