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

revExecuteSQL


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



More information about the Use-livecode mailing list