Hi All,
Here my statements to insert rows into the database
  Open the database connection
  BEGIN
        insert ...using sqlite3_step
        insert ...using sqlite3_step
  END
So at the time I issued "END" transaction I got the error message SQLITE_BUSY 
so I need to issue the "END" transaction again or What should I do in this case 
to handle SQLITE_BUSY.
Thanks a lot in advance for the help or advice.
JP



----- Original Message ----
From: Joanne Pham <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Wednesday, November 28, 2007 11:27:52 AM
Subject: [sqlite] SQLITE_BUSY retry

Hi All,
I have used "BEGIN" and "END" Transaction to insert the data to SQLite database.
    BEGIN
        insert ...
        insert ...
  END

When I issued the "END" operation the error message return back is 
"SQLITE_BUSY". 
What should I do if I want to handle SQLITE_BUSY /retry the transaction. Should 
I execute "END" transaction again.
How to handle the SQLITE_BUSY?
Thanks,
JP


      
____________________________________________________________________________________
Get easy, one-click access to your favorites. 
Make Yahoo! your homepage.
http://www.yahoo.com/r/hs


      
____________________________________________________________________________________
Be a better sports nut!  Let your teams follow you 
with Yahoo Mobile. Try it now.  
http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ

Reply via email to