I think you could set pxdb->pBe->inTrans field to 0 to indicate the transaction is finished.
2006/3/2, nbiggs <[EMAIL PROTECTED]>: > 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 > > > > > >
