remedial mysql???
Bob Sneidar
bobs at twft.com
Mon Aug 20 11:52:59 EDT 2012
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
More information about the use-livecode
mailing list