With FTS3 can you specify the rowid to use in SQL or is it always automatic? It seems like most commonly you'd want the FTS data to match up with a real table using the same key and not have to store the FTS key in a separate table. Ideally I'd want to be able to include a single foreign key indexed integer field so a FTS table would like like:
OID FK_ID FTS_FIELDS So you can associate multiple FTS records with a single standard record without having to create a linking table (linking tables typically define a many-to-many relationship and here we have a one-to-many relationship). FTS's job isn't to enforce constraints, but it allowing users to link FTS data to regular data. Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building Flex based products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
