[sqlite] FTS3: (1) cloning index rows? (2) not storing original text?

Dear All, After some searching I still could not find the answers to the following questions. Any answers or pointers would be greatly appreciated. (1) In my FTS-enabled database, I want to clone some document, stored in a binary format. (Which means copying the same contents to a new row with a

[sqlite] sqlite3_step returns SQLITE_OK

** In the legacy interface, the return value will be either [SQLITE_BUSY], ** [SQLITE_DONE], [SQLITE_ROW], [SQLITE_ERROR], or [SQLITE_MISUSE]. ** With the "v2" interface, any of the other [SQLITE_OK | result code] ** or [SQLITE_IOERR_READ | extended result code] might be returned as ** well. the a

Re: [sqlite] Updating same tables in attached databases.

On Sun, 3 Aug 2008 22:16:31 -0700 (PDT), you wrote: > I have two databases, an in memory main database > consisting of a single table, and a disk based > database consisting of multiple tables one of which > is also the same table as the one in memory database. > > Let's say in memory database ta

Re: [sqlite] Default text column values

On Mon, 04 Aug 2008 12:47:24 +0100, you wrote: >Thanks Emilio and Kees for doing what should have done - a bit of basic >SQL! > >Well the problem has been narrowed down to the the Show Table/Modify >Data function in SQLit3Manager. If I just do a simple insert from there >the default text does n

[sqlite] Default text column values

Thanks Emilio and Kees for doing what should have done - a bit of basic SQL! Well the problem has been narrowed down to the the Show Table/Modify Data function in SQLit3Manager. If I just do a simple insert from there the default text does not appear. The numeric defaults are ok however. Maybe