On Jan 19, 2011, at 10:03 AM, Richard Hipp wrote:
> On Wed, Jan 19, 2011 at 12:35 PM, James Berry <[email protected]> wrote:
>
>> I'm trying to understand whether there's any problem with committing a
>> transaction while in the process of stepping over results.
>
> The ability to do this was added to SQLite in version 3.6.5 in November of
> 2008.
Thanks Richard, for the clarification.
James
>> BEGIN DEFERRED TRANSACTION
>>
>> SELECT * FROM a
>> sqlite3_step over select results
>> {
>> COMMIT
>> BEGIN DEFERRED TRANSACTION
>>
>> INSERT INTO b
>> }
>>
>> COMMIT
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
