I think that I just found my problem. For some stupid reason, I coded it so that if a statement failed, then it stopped executing the rest of the statements. Thus leaving the transaction open and causing my problems. I have since fixed it.
-----Original Message----- From: Rob Lohman [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 01, 2006 5:09 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Failing Transaction Help. 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: <sqlite-users@sqlite.org> 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 > >
