Thank you, Dr. Hawkins! I have not heard of BEGIN TRANSACTION but I will give it a try.
John Balgenorth John On Mar 24, 2015, at 8:13 PM, Dr. Hawkins <[email protected]> wrote: > On Tue, Mar 24, 2015 at 6:52 PM, Peter Haworth <[email protected]> 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 > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
