When I do everything without a transaction, it is written correctly, but I don't want it because I first empty the whole table. Now if the pc crashes, everything is lost. And that's not what I want... So only when the complete 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 a transaction when committing?
At 09:11 3/12/2004, you wrote:
Hi Steven,
I used transactions in C++ code (windows and linux) with sqlite 2.8;
try the sequence " BEGIN; DELETE ...; INSERT ...; COMMIT; ", it works in 2.8.
Regards
Paolo
----- Original 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 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 already in a transaction? Is that possible or should I look further?
Does a commit end the transaction, or should I end it anyhow?
Thx,
KaReL (aka Steven)
Main Webpage : http://www.karels0ft.be/
ICQ # : 35217584
KaReL (aka Steven)
Main Webpage : http://www.karels0ft.be/
ICQ # : 35217584
KaReL (aka Steven)
Main Webpage : http://www.karels0ft.be/
ICQ # : 35217584
pgpZbry6ZHQ7y.pgp
Description: PGP signature
