Re: [sqlite] Transaction question

2013-04-26 Thread Igor Tandetnik
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

[sqlite] Transaction question

2013-04-26 Thread Igor Korot
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

Re: [sqlite] transaction question

2008-10-14 Thread Dan
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

[sqlite] transaction question

2008-10-14 Thread Gene Allen
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

Re: [sqlite] TRANSACTION-question

2004-12-03 Thread [EMAIL PROTECTED]
-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

Re: [sqlite] TRANSACTION-question

2004-12-03 Thread D. Richard Hipp
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

Re: [sqlite] TRANSACTION-question

2004-12-03 Thread Steven Van Ingelgem
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

Re: [sqlite] TRANSACTION-question

2004-12-03 Thread P. Morandi
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

Re: [sqlite] TRANSACTION-question

2004-12-03 Thread Steven Van Ingelgem
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

Re: [sqlite] TRANSACTION-question

2004-12-03 Thread P. Morandi
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

[sqlite] TRANSACTION-question

2004-12-02 Thread Steven Van Ingelgem
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