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
