Jay A. Kreibich wrote: > > you can create a trigger that fires on an attempt to > DELETE, INSERT, or UPDATE a view and do what you need > in the body of the trigger. > > Jay, this is exactly what the OP did.
He has two tables and a view, and inserts into the two tables from within an "instead of" trigger on the view. I suspect the error is due to the fact that one of the tables is an FTS3 virtual table rather than a real table. I haven't used the FTS3 module much so I can't offer any further insight, but I see nothing wrong with the code as posted. Perhaps the OP should file a bug report using this example. If there is a bug it will probably be fixed in short order. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
