SQL lite adding records

JB 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.

John Balgenorth


John
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
> 
> revExecuteSQL
> 
> 
> -- 
> 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:
> http://lists.runrev.com/mailman/listinfo/use-livecode
> 





More information about the Use-livecode mailing list