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 <doch...@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@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
