I am following the fts2 instructions in fts3. Assuming a table
CREATE TABLE article (article_id INTEGER PRIMARY KEY, article_name,
article_text);
I created
CREATE VIRTUAL TABLE fts_article USING fts3 (article_name, article_text);
But when I try to
INSERT INTO fts_article (row_id, article_name, article_text)
VALUES (article_d, article_name, article_text)
I get the error --
table fts_article has no column named row_id
Needless to say, this didn't happen with fts2. Any guidance would be
appreciated.
--
Puneet Kishor
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
