SQL lite adding records
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
put "END TRANSACTION;" & cr after dcmd
Dr. Richard E. Hawkins, Esq.
More information about the Use-livecode