You don't HAVE to remove the START/COMMIT, I was pointing out that they are superfluous. Leave them in if you wish.
The semicolon issue has nothing to do with what mySQL requires, it's a Livecode requirement - see the dictionary. Finally, if you're using revDataFromQuery to do this, I'm surprised it ever worked. You're not getting data from a query, you're executing SQL commands so you need to use revExecuteSQL. Pete lcSQL Software <http://www.lcsql.com> On Sat, Aug 18, 2012 at 11:05 AM, Dr. Hawkins <doch...@gmail.com> wrote: > MySQL explicitly supports the semicolons, the multi-line, and the > START/COMMIT syntax. > > I have to remove *all* of these to get revDataFromQuery to work . . . > > This seems a bit . . . odd . . . > _______________________________________________ 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
