If I'm not mistaken you still need to close the transaction. Are you doing an "end transaction" even if a statement fails (ie, a rollback is done)?
----- Original Message ----- From: "nbiggs" <[EMAIL PROTECTED]>
To: <[email protected]> Sent: Wednesday, March 01, 2006 10:24 PM Subject: [sqlite] Failing Transaction Help.
In my application, I am using a transaction to insert about 10 records at a time. The problem is that if one of the statements in the transaction fail, commit is not being executed. When I try creating another transaction, I get a constant error message "can not create a transaction within a transaction". How do I get around this issue? Nathan Biggs Computerway Food Systems (336) 841-7289
