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



_______________________________________________
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

Reply via email to