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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to