Re: Execute multiple MySQL commands
On Thu, Feb 8, 2018 at 8:20 AM, Ludovic THEBAULT via use-livecode < use-livecode@lists.runrev.com> wrote: > > > Just for infos, multiple statements works with SQLite but not with Mysql. They also work with postgreSQL. This was a major factor in my switching. I think mySQL now has rollback, but it didn't have fun rollback at the time, either. Overall, postgres is the more mature/stable of the two, but it doesn't come "canned" on very many ISPs. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 ___ 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
Re: Execute multiple MySQL commands
NP. From the dictionary statement about *some* database systems supporting multiple SQL statements, I gather that *some* do not, so they have to take the lowest common denominator approach. Bob S > On Feb 8, 2018, at 08:07 , Ludovic THEBAULT via use-livecode > wrote: > >> Le 8 févr. 2018 à 16:34, Bob Sneidar via use-livecode >> a écrit : >> >> I thought I read somewhere that the LC API does not support multiple >> statements? >> >> Bob S > > > Ok, thanks ! ___ 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
Re: Execute multiple MySQL commands
> Le 8 févr. 2018 à 16:48, Bob Sneidar via use-livecode > a écrit : > > I know where! The Dictionary: > > > SQLStatement string > A string in Structured Query Language. (Do not include a semicolon at the end > of the SQLStatement.) >Note: Some database systems, such as Oracle, are > capable of handling a multiple-line SQL statement. > > Bob S Just for infos, multiple statements works with SQLite but not with Mysql. ___ 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
Re: Execute multiple MySQL commands
> Le 8 févr. 2018 à 16:34, Bob Sneidar via use-livecode > a écrit : > > I thought I read somewhere that the LC API does not support multiple > statements? > > Bob S Ok, thanks ! ___ 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
Re: Execute multiple MySQL commands
I know where! The Dictionary: SQLStatementstring A string in Structured Query Language. (Do not include a semicolon at the end of the SQLStatement.) >Note: Some database systems, such as Oracle, are capable of handling a multiple-line SQL statement. Bob S > On Feb 8, 2018, at 07:34 , Bob Sneidar via use-livecode > wrote: > > 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 >> 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 ___ 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
Re: Execute multiple MySQL commands
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 > 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