Greetings all, It is well known that you cannot create triggers against virtual tables and fts4 tables are a form of virtual table.
Has anyone developed a work around method for this or simulating the end effect? I have a full text search table which is comprised of joining and selecting from some underlying tables. I need to synch this full text search table with underlying tables upon insert or update (of the full text search table). A trigger would be ideal here but you can't use them against virtual tables. I'm sure someone has run into this same dillema. Thanks for any suggestions. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
