Some basic questions: I have been creating the fts virtual table at the start of my program like this:
CREATE VIRTUAL TABLE ItemFts USING FTS3(ItemId, ItemName, Description); INSERT INTO ItemFts (ItemId, ItemName, Description) SELECT ItemId, ItemName, Description FROM Item"; As rows are added to the Item table is it possible to add additional rows to the ItemFts table? I have been getting a weird error that the ItemFts table does not exist using this command (ItemID is set in code of course). INSERT INTO ItemFts (ItemId, ItemName, Description) SELECT ItemId, ItemName, Description FROM Item WHERE ItemID = 42; Also, it is necessary to create the ItemFts table every time my program runs? I find that the table is not deleted when the database connection is closed. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
