SQL lite adding records

Dr. Hawkins dochawk at gmail.com
Tue Mar 24 23:13:54 EDT 2015

On Tue, Mar 24, 2015 at 6:52 PM, Peter Haworth <pete at 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


Dr. Richard E. Hawkins, Esq.
(702) 508-8462

More information about the Use-livecode mailing list