Hmmm that is interesting I didn't know that. What happens if you already have a transaction started then? I ask because sqlYoga has a transaction command. I have to think that if you start a transaction mySQL would use that transaction instead of starting another (if that were even possible).
Bob On Aug 18, 2012, at 10:38 AM, Peter Haworth wrote: > Assuming mySQL will accept multiple statements, I believe Livecode wants > you to omit the semicolon statements at the end of each line. > > Your START and COMMIT statements are superfluous in this case since SQL > automatically wraps single statements in a transaction so I'd remove them > and avoid whatever issue is causing the multi-line problem. > > Pete _______________________________________________ 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
