[sqlite] any way to find out how many current connections to db?

is there any way (in c/c++) to find out how many current connections there are to a database that i am connected to? i'd like to do some housekeeping on the database every so often, but only if there's no one else connected to it at the time. any ideas? thanks. - chase

[sqlite] any way to find out how many current connections to db?

is there any way (in c/c++) to find out how many current connections there are to a database that i am connected to? i'd like to do some housekeeping on the database every so often, but only if there's no one else connected to it at the time. any ideas? thanks. - chase

Re: [sqlite] how to create C functions and refer to them in sql

**INSTALL/EMBED** my custom function **into** the database file. - chase On August 6, 2007, Eugene Wee wrote: You are probably looking for sqlite3_create_function: http://www.sqlite.org/capi3ref.html#sqlite3_create_function Regards, Eugene Wee Chase wrote: i need a trigger to create

[sqlite] SQLITE_BUSY database is locked when db is on network drive...

(which, like i said, works if the db is local) it fails immediately with SQLITE_BUSY database is locked. NO ONE else is accessing this database file, so how is that possible? what am i doing wrong? - chase

[sqlite] SQLITE_BUSY database is locked when db is on network drive...

(which, like i said, works if the db is local) it fails immediately with SQLITE_BUSY database is locked. NO ONE else is accessing this database file, so how is that possible? what am i doing wrong? - chase

[sqlite] database is locked SQLITE_BUSY when db is on network drive...

(which, like i said, works if the db is local) it fails immediately with SQLITE_BUSY database is locked. NO ONE else is accessing this database file, so how is that possible? what am i doing wrong? - chase

[sqlite] how do i declare and use variables in sqlite?

the documentation on this subject. can someone shed some light on this for me? thanks. - chase - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] sqlite3_update_hook does not get called when other app updates shared db

of this function was to get callbacks on any **outside** tinkering with a shared database file. Can someone please shed some light on this. Thank you. - Chase - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] CREATE INDEX that is case insensitive?

DC De Do If, however, it has nothing to do with the index and instead we should deal with this in the SELECT, that's fine. In that case, tell me what that SELECT statement would look like. Thanks. - Chase

Re: [sqlite] CREATE INDEX that is case insensitive?

net result, but it would add, of course, to the size of the db. like: foo UPPERFOO TestTEST any ideas? - chase On July 30, 2007, Chase wrote: Right now, when i do a select in sqlite that is supposed to be in alphabetical order, i get: DC Da De Do instead of: Da DC

[sqlite] how do i generate a uniqueidentifier ?

how do i generate a uniqueidentifier ? - chase - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] how do i generate a uniqueidentifier ?

-8000-00AA006D2EA4}AaaBbb so how is this done in sqlite3? - chase On July 27, 2007, Mark Richards wrote: Chase wrote: how do i generate a uniqueidentifier ? Define a column as follows: {fieldname} INTEGER NOT NULL PRIMARY KEY eg: CREATE TABLE hardware_types (record_key