On Tue, Mar 24, 2015 at 6:52 PM, Peter Haworth <p...@lcsql.com> wrote:

> You should issue a BEGIN statement right before your repeat statement and
> move your revCommitDatabase to right after the end repeat.  Better
> performance and guarantees db integrity.
>

Also, you can build a large statement for a single transactoin

put "BEGIN TRANSACTION;" & cr into dcmd

repeat in some way or another
put "SOME COMMAND;" & cr after dcmd
end repeat

put "END TRANSACTION;" & cr after dcmd

revExecuteSQL


-- 
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