remedial mysql???

[Bob Sneidar]

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