Execute multiple MySQL commands

[Bob Sneidar]

I thought I read somewhere that the LC API does not support multiple statements? 

Bob S


> On Feb 8, 2018, at 02:24 , Ludovic THEBAULT via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hello,
> 
> I’ve an « syntax error » as result if i want to execute multiple MySQL commands, even with transactions.
> 
> It is normal ? If i execute one command at time, it’s work.
> 
> Thanks !
> 
> 
> 
> Here a sample script :
> 
> revExecuteSQL tDatabaseID,"BEGIN TRANSACTION »
> 
> put "INSERT INTO savemyTable (column1) VALUES (1)  & ";" & cr into tSQL
> 
> put "DELETE FROM myTable WHERE id = " & id & ";" & cr after tSQL
> 
> revExecuteSQL tDatabaseID, tSQL
> 
> if the result is not an integer then answer the result
> 
> else …// COMMIT