Re: [sqlite] fts3 complains no column named row_id

On Mon, Feb 18, 2008 at 9:48 PM, P Kishor <[EMAIL PROTECTED]> wrote: > 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. Are you sure? fts2 didn't have row_id, either. In either case, it

[sqlite] fts3 complains no column named row_id

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,