[sqlite] Can I index a single text column on a fts table?

I'm not sure if I understood the fts table declaration format and posibilieties but is it possible to make SQLite index only a single text column in a table containing multiple text columns? -- View this message in context:

Re: [sqlite] How to use the ROWID of the last inserted row for FK insert into other tables?

Igor Tandetnik wrote: > > "alp" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> I have to tables(TBL_OBJECTS, TBL_TAGS) and I want to use the ROWID >> of the last inserted row from table TBL_OBJECTS to insert a new row >> in TBL_TA

[sqlite] How to use the ROWID of the last inserted row for FK insert into other tables?

Hello, I have to tables(TBL_OBJECTS, TBL_TAGS) and I want to use the ROWID of the last inserted row from table TBL_OBJECTS to insert a new row in TBL_TAGS table with the ID_OBJECT foreign key set to the ROWID value from the precedent table. This is the tables definition: CREATE TABLE