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