[OT] mySQL Client
bobsneidar at iotecdigital.com
Mon Dec 12 19:18:20 EST 2016
That is odd. I recently did that very thing. I started a transaction and then ran multiple updates in a repeat loop, then committed the transaction. Seemed like all the data ended up in the tables.
> On Dec 10, 2016, at 12:16 , Dr. Hawkins <dochawk at gmail.com> wrote:
> One thing to note: at the moment (and future???), you cannot send compound
> transactions from LiveCode to mySQL. I understand this to be a livecode
> BEGIN TRANSACTION;
> INSERT THIS;
> SELECT THAT;
> DO SOMETHING ELSE;
> END TRANSACTION;
> can be handled with a single query in livecode with SQLite and postgreSQL,
> but requires five separate transactions for mySQL.
> If latency is an issue, this is a killer . . .
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode