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

2007-08-13 Thread Chase
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?

2007-08-11 Thread Chase
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

2007-08-06 Thread Chase
**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] how to create C functions and refer to them in sql

2007-08-06 Thread Chase
? my understanding was that sqlite allows for user functions written in C and used from within your sql code, but i forget where i saw that and i'm so far unable to find in the docs where it shows how this is done. anyone done this before? - chase

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

2007-08-02 Thread Chase
alled, and vice versa. I thought the whole point 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] how do i declare and use variables in sqlite?

2007-08-02 Thread Chase
can't find the documentation on this subject. can someone shed some light on this for me? thanks. - chase - To unsubscribe, send email to [EMAIL PROTECTED] -

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

2007-08-02 Thread Chase
(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

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

2007-08-02 Thread Chase
(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

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

2007-08-02 Thread Chase
(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

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

2007-07-30 Thread Chase
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] CREATE INDEX that is case insensitive?

2007-07-30 Thread Chase
hich would spit out: Da 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

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

2007-07-27 Thread Chase
{0109--0010-8000-00AA006D2EA4}"Aaa""Bbb" 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

[sqlite] how do i generate a uniqueidentifier ?

2007-07-27 Thread Chase
how do i generate a uniqueidentifier ? - chase - To unsubscribe, send email to [EMAIL PROTECTED] -