SQL lite adding records
sundown at pacifier.com
Tue Mar 24 23:19:50 EDT 2015
Thank you, Dr. Hawkins!
I have not heard of BEGIN TRANSACTION
but I will give it a try.
On Mar 24, 2015, at 8:13 PM, Dr. Hawkins <dochawk at gmail.com> wrote:
> 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
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode