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