On Tue, Jul 1, 2008 at 3:24 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > CREATE TRIGGER .... > BEGIN > insert into temp_table > select * from perm_table > where <the data is currently not in temp table> and > <which record you want copied>; > > update temp_table set ...; > END; I had thought of this, but I'm pretty sure this will only work correctly the first time you try to update the view. Subsequent calls will try to copy the data into the temp table, but correctly fail. However, that means the update will never actually run, correct?
Cheers, Shawn _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users