[OT] mySQL Client

Dr. Hawkins dochawk at gmail.com
Sat Dec 10 15:16:50 EST 2016


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



More information about the Use-livecode mailing list