Re: [sqlite] step() fails with SQLITE_BUSY after BEGIN EXCLUSIVETRANSACTION

I have no idea why it doesn't work in that way, it used to in my application. however, just a few points: maybe your BEGIN wasn't successful and you didn't realize ? maybe you run the INSERT on a DB handle that was not the one that invoked the BEGIN ? maybe your COMMIT wasn't successful and you

Re: [sqlite] step() fails with SQLITE_BUSY after BEGIN EXCLUSIVETRANSACTION

Marcus thanks for your suggestions. I have of course checked the obvious things before posting here. Both the BEGIN EXCLUSIVE and the COMMIT return SQLITE_OK. Each thread opens its own db handle with sqlite_open and operates on it. These are completely isolated, they don't know about each

Re: [sqlite] Heuristics of when to vacuum

On Sat, 11 Apr 2009 20:16:32 -0700, Tito Ciuro wrote: >Hi Lawrence, > >On Apr 11, 2009, at 7:51 PM, Lawrence Gold wrote: > >> I can't offer a formula, but I suggest making it an option for the >> users of the software, with sufficient warning that it could take some >> time, as

Re: [sqlite] Heuristics of when to vacuum

Hi Kees, On Apr 12, 2009, at 5:27 AM, Kees Nuyt wrote: > PRAGMA freelist_count; tells you how many pages are free. > If there are many free pages, you may have a reason to > vacuum. It doesn't tell anything about the average > percentage of payload in database pages, which would be > another

Re: [sqlite] Heuristics of when to vacuum

Hi, On Mon, Apr 13, 2009 at 12:40 AM, Tito Ciuro wrote: > One question, when I run the command I see that the fragmentation in > "All tables" is greater than "All tables and indices". How can that > be? The sum of all tables and their indices doesn't add up (10.6% + > 7.5% ≠

Re: [sqlite] Sqlite, vb6 and date time field

"Rene Claassen" schrieb im Newsbeitrag news:64d5d370904090322t2f2b24f2pf8aafb4963fd0...@mail.gmail.com... > How can I convert it into a string through ODBC? Here is some of my data. > > Date_Stamp > 2009/03/16 10:52 > ... I assume, this is a "textbased Date" - normally

Re: [sqlite] Heuristics of when to vacuum

Hi Eugene, On 12 Apr 2009, at 9:53 AM, Eugene Wee wrote: > Hi, > > On Mon, Apr 13, 2009 at 12:40 AM, Tito Ciuro wrote: >> One question, when I run the command I see that the fragmentation in >> "All tables" is greater than "All tables and indices". How can that >> be? The sum of

[sqlite] fail to drop table in transaction

I created two tables A and B. There exists a record which contains B's information. Now I need to drop table B and delete all its information in table A. The two actions were wrapped in a transaction,but dropping table always fail. Error no is SQLITE_CANTOPENwhich means"Unable to open