Re: [sqlite] caching

I am sorry, I should have made some clarifications about the way the wrapper is implemented, let me answer your concerns. I see many problems here: * It fails if your update or delete from a different database connection or a different process such that the update or delete is not

Re: [sqlite] caching

<[EMAIL PROTECTED]> wrote: > > when an update or delete is made to the database all > queries that are possibly affected are requeried and > cached again rather than being removed, once every 20 > updates/deletes a clean up routine is invoked. I see many problems here: * It fails if your up

[sqlite] caching

Hi, I have a COM component to which sqlite++ library was added, now I want to improve caching of queries. It's already working speeding up nicely by caching each query, but it uses a setting for how many queries to cache and for how long. I believe in automating everything that's possible, so

Re: [sqlite] How to take off a lock on a table

Salvador Ramirez <[EMAIL PROTECTED]> wrote: > Hello, > > I am having a problem with a table on a sqlite3 database > related with a lock that left by a program that died > abnormally in the middle of a select operating initiated > with a call to sqlite3_prepare(). Now I wonder how to take >

[sqlite] Fw: select help

Hi have this table CREATE TABLE [blocklists] ( [blockval] VARCHAR(255) NOT NULL ) insert into blocklists blockval values('%lex%'); and I need do something like this select count(*) from blocklists where 'alexandre' like blockval How i can do something like with sqlite? That i need is