[sqlite] Callback FUnctions

Hi all, Does sqlite have support for callback functions ? ie: asyncronous queries ? cheers James -- -- -"Problems are Solved by Method" - - James Mills <[EMAIL PROTECTED]> - HomePage: http://shortcircuit.net.au/~prologic/ - IRC: irc://shortcircuit.net.au#se Please avoid sending me Word or Powe

Re: [sqlite] Re: autoincrement and fts2?

Adam, As it currently stands, fts2 (and fts1, if you ever do a delete) is broken if you use VACUUM. It's not an issue of how the table is defined, it's an issue of the internal definitions - when fixed, it will just be fixed, you won't define your tables differently. [There's been some discussio

Re: [sqlite] undefined reference to `sqlite3_open'

Thanks all, it's work fine now :) On 7/19/07, John Stanton <[EMAIL PROTECTED]> wrote: You don't seem to have the sqlite3 link library in your compile and link command. MaaSTaaR wrote: > Hello ... > > firstly, sorry for my bad English. > > i am using SQLite with C under Linux, i wrote small fi

Re: [sqlite] Enclosing quotes

Hi Gerry, Thanks for your reply. When I rename a table, SQLite seems to override the quote characters I use, instead using single quote marks. Is this a bug? The quote characters used in creating a table are not part of the table name. Yes, I understand that they're not part of the name.

[sqlite] Re: How to change journal location?

Simon Posnjak <[EMAIL PROTECTED]> wrote: Is there a way to change the location of the journal file? We would like to have journal in some other directory than the database. You can't. If your application crashes in the middle of a transaction, whoever next opens the database must be able to de

Re: [sqlite] invalid subselect is not detected ?

On 7/21/07, Joe Wilson <[EMAIL PROTECTED]> wrote: --- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > > > (In the 5 hour lag it takes to post to the list, this has > > probably already been answered 5 times, but what the heck...) > > > > I'd love for you to work on the slow

[sqlite] Re: autoincrement and fts2?

"Scott Hess" <[EMAIL PROTECTED]> writes: > In fts tables all columns other than rowid are of type TEXT. It > doesn't matter what you put in the type, they will be of type TEXT. > The rowid is the standard SQLite rowid, so it does provide an INTEGER > PRIMARY KEY AUTOINCREMENT column. Scott, than

[sqlite] How to change journal location?

Hi all! Is there a way to change the location of the journal file? We would like to have journal in some other directory than the database. Regards Simon -- Simon Posnjak Četrta pot, d.o.o. Planina 3 4000 Kranj Slovenija, EU ---

Re: [sqlite] Enclosing quotes

T&B wrote: Hi All, When I rename a table, SQLite seems to override the quote characters I use, instead using single quote marks. Is this a bug? The quote characters used in creating a table are not part of the table name. SQLite just uses apostrophes, aka single quotation marks, aka single

[sqlite] Enclosing quotes

Hi All, When I rename a table, SQLite seems to override the quote characters I use, instead using single quote marks. Is this a bug? I prefer to use double quotes or square brackets for entity and column names (aka "user-defined objects"), obeying the SQLite documentation, but SQLite over

Re: [sqlite] invalid subselect is not detected ?

--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > > > (In the 5 hour lag it takes to post to the list, this has > > probably already been answered 5 times, but what the heck...) > > > > I'd love for you to work on the slow email problem for me, Joe. > Call me at my office