Use view + triggers on view. Triggers on view can modify FTS4 table and any other.
2011/11/22 Ephraim Stevens <ephraim.stev...@gmail.com>: > 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 > -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
