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 <doch...@gmail.com> wrote: > 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 > _______________________________________________ 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
