Livecode can't handle multi-line mySQL transactions in a single
livecode
transaction! You need to send the commands individually, and then
commit
(A non-starter for me, as the enemy is network latency, not bandwidth
or
load on the SQL server).
The current revDB API isn't really set up to ha
Trying to have something usable by others while I get the server going, I
took another try at mySQL today--and, after a few hours and web searches,
got reminded why I stopped . . .
Livecode can't handle multi-line mySQL transactions in a single livecode
transaction! You need to send the commands