Consider CREATE VIRTUAL TABLE fts_text USING fts4 (id, content);
.. populate the above table, then .. SELECT rowid, Snippet(fts_text) FROM fts_text WHERE fts_text MATCH ?; If I try to do something like CREATE VIEW v_find AS SELECT rowid, Snippet(fts_text) content FROM fts_text; SELECT rowid, content FROM v_find WHERE fts_text MATCH ?; I understandably get an error "no such column fts_text". The above is a contrived example, but can I build a view out of a complicated fts query so I can then pass parameters to the view later on? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users