[OT] mySQL Client

Bob Sneidar bobsneidar at iotecdigital.com
Tue Dec 13 01:18:20 CET 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. 

Bob S


> 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
> issue.
> 
> So
> 
> 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:
> http://lists.runrev.com/mailman/listinfo/use-livecode




More information about the use-livecode mailing list