RE: [sqlite] Btree

I used the SQLite BTree for indexing. If you are doing complex query, I think you are much better off with SQL... The btree API is undocumented (documented somewhat in the source files) and unsupported. If you are gonna do that, I had recently posted some problems/solutions I encounter using

RE: [sqlite] Second Btree Transaction stuck at commit

eClean()??? -Original Message- From: William Chan [mailto:[EMAIL PROTECTED] Sent: Friday, August 11, 2006 12:11 AM To: 'William Chan'; 'sqlite-users@sqlite.org' Subject: RE: [sqlite] Second Btree Transaction stuck at commit Hi Richard, I found out I did not solve the problem yesterday because the

RE: [sqlite] Second Btree Transaction stuck at commit

(pChk == pPg) return; // jump out if same entry is on the list pChk = pChk->pDirty; } ... // original code continues. } It seems to work now. I am not sure what's the "right" way to fix this since I am new to the code. Regards, William -Original Message-

RE: [sqlite] Second Btree Transaction stuck at commit

. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 7:09 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Second Btree Transaction stuck at commit "William Chan" <[EMAIL PROTECTED]> wrote: > Hi Guys, > > I think I figu

RE: [sqlite] Second Btree Transaction stuck at commit

Hi Guys, I think I figure out my problem. Looks like I need to close the cursor and create a new cursor between the two Btree transactions. Then the second btree commit will go thru. Can someone explain to me why? Thanks. Regards, William -Original Message- From: William Chan

[sqlite] Second Btree Transaction stuck at commit

Hi, I wrote a test program for the Sqlite btree functions. First I start a btree transaction to create the table and insert a few record then I commit the btree transaction, after that I try to start btree transaction to delete some record. Everything returns successful until I try to commit