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 <doch...@gmail.com> wrote: > On Tue, Nov 11, 2014 at 1:09 PM, Peter Haworth <p...@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
