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@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 _______________________________________________ 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
