Re: [sqlite] TRANSACTION-question

[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 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