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:
http://www.nabble.com/Can-I-index-a-single-text-column-on-a-fts-table--t
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_TAGS
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 TBL_OBJE
3 matches
Mail list logo