On Jan 19, 2011, at 9:43 AM, Igor Tandetnik wrote:
> On 1/19/2011 12:35 PM, James Berry wrote:
>> I'm trying to understand whether there's any problem with committing a
>> transaction while in the process of stepping over results.
>
> I believe COMMIT would fail while there is an outstanding statement on
> the connection.
If that's the case, then is the following pseudo code any better?
SELECT * FROM a
count == 0
sqlite3_step over select results
{
if (count == 0)
BEGIN DEFERRED TRANSACTION
else if (count % transactionSize == 0) {
COMMIT
BEGIN DEFERRED TRANSACTION
}
++count
INSERT INTO b
}
COMMIT
>
>> The codes seems to be working for me
>
> Check return values from various SQLite calls.
> --
> Igor Tandetnik
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
