On 4/26/2013 7:18 PM, Igor Korot wrote:
If I'm inside transaction and want to insert a record, will I see right
after executing sqlite3_step() or I have to execute a "COMMIT" statement to
see it?
The connection that executed sqlite3_step() would see its own changes
right away. Other
Hi, ALL,
If I'm inside transaction and want to insert a record, will I see right
after executing sqlite3_step() or I have to execute a "COMMIT" statement to
see it?
Thank you.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Oct 14, 2008, at 9:06 PM, Gene Allen wrote:
> I have a large sqlite database and I'm inserting a bunch of records
> into it.
> My question is this..shouldn't the -journal be getting larger since
> I've
> wrapped all the inserts inside a transaction?
>
>
>
> I'm watching the file sizes
I have a large sqlite database and I'm inserting a bunch of records into it.
My question is this..shouldn't the -journal be getting larger since I've
wrapped all the inserts inside a transaction?
I'm watching the file sizes change and the main file is getting larger, but
the journal files is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mime-Version: 1.0
Content-Type: multipart/mixed; x-avg-checked=avg-ok-786B32B5;
boundary="===176C28DF==="
- --===176C28DF===
Content-Type: text/plain; x-avg-checked=avg-ok-786B32B5; charset=us-ascii;
format=flowed
Steven Van Ingelgem wrote:
Hi,
I do the following (SQLite 308 from C++ source in windows):
BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT
TRANSACTION; END TRANSACTION;
Now, nothing is done? Nothing inserted, nothing deleted from Inbox...
Probably you are encountering an error
transaction is finished I want it to continue.
At 10:26 3/12/2004, you wrote:
Yes, you do it.
Bye
- Original Message -
From: Steven Van Ingelgem
To: [EMAIL PROTECTED]
Sent: Friday, December 03, 2004 10:02 AM
Subject: Re: [sqlite] TRANSACTION-question
Do you automatically end
Yes, you do it.
Bye
- Original Message -
From: Steven Van Ingelgem
To: [EMAIL PROTECTED]
Sent: Friday, December 03, 2004 10:02 AM
Subject: Re: [sqlite] TRANSACTION-question
Do you automatically end a transaction when committing?
At 09:11 3/12/2004, you wrote:
Hi
al Message -
From: Steven Van Ingelgem
To: [EMAIL PROTECTED]
Sent: Friday, December 03, 2004 8:51 AM
Subject: [sqlite] TRANSACTION-question
Hi,
I do the following (SQLite 308 from C++ source in
windows):
BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT
TRANSACTION; END T
2004 8:51 AM
Subject: [sqlite] TRANSACTION-question
Hi,
I do the following (SQLite 308 from C++ source in windows):
BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT TRANSACTION;
END TRANSACTION;
Now, nothing is done? Nothing inserted, nothing deleted from Inbox...
Th
Hi,
I do the following (SQLite 308 from C++ source in windows):
BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT
TRANSACTION; END TRANSACTION;
Now, nothing is done? Nothing inserted, nothing deleted from
Inbox...
Then I tried to execute the same afterwards, but then I got that I am
11 matches
Mail list logo