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
pgp28wWEMi9Uy.pgp
Description: PGP signature
