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

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

[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

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,

[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 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

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