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
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
. how to i **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
?
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?
-
called, 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]
-
#x27;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]
-
temp table
(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
temp table
(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
temp table
(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
tle and index that. same net result, but it
would add, of course, to the size of the db.
like:
foo UPPERFOO
Test TEST
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
creating an INDEX which 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
o i guess it's just a text type under the hood with no rules enforced
on the format of the string inserted into it.
not sure if i like that.
- chase
ps: thanks for the help on generating a guid.
On July 27, 2007, Chris Wedgwood wrote:
On Fri, Jul 27, 2007 at 01:47:33PM -0700, Chris
{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} INTEG
how do i generate a uniqueidentifier ?
- chase
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
14 matches
Mail list logo
