Ditto what Mike said: 

" On mysql..  can't you prebuild your multi-command transaction in a variable"

I periodically do this kind of thing. assuming the transaction is exactly the 
sameā€¦ one way is to build a single SQL query from your data.

Assume you need something like this, getting and SQL query into a string, from 
raw data with LC's text processing tools is easy:

INSERT INTO `mytable` (item,quantity,amount)
#(no problem doing 2000 of these)

and then do the insert as a single query/transaction and let the dBase handle 

On 12/29/17, 3:05 PM, "use-livecode on behalf of Mike Bonner via use-livecode" 
<use-livecode-boun...@lists.runrev.com on behalf of 
use-livecode@lists.runrev.com> wrote:

    (with a beginning and ending to the transaction) and then use revexecutesql
    with a single call for the one big transaction?

use-livecode mailing list
Please visit this url to subscribe, unsubscribe and manage your subscription 

Reply via email to