Hi all: Assuming a normal table:
CREATE TABLE names (Id INTEGER PRIMARY KEY, Nm INTEGER); And an FTS4 table: CREATE VIRTUAL TABLE fts USING fts4 (name, tokenize=simple); I want populate the FTS4 table from the content of the names table using the second form of the INSERT statement: INSERT INTO fts (rowid, name) SELECT so.Id, so.Nm FROM names so WHERE (so.Id>1000 AND so.Id<2000); I get an Error:constraint failed Even if I use an statement that does not return error, I.e: INSERT INTO fts (name) SELECT so.Nm FROM names so WHERE so.Id>1000; The result do nothing although the names table is populated. Any clue would be appreciated. -- Adolfo _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
