"J. King" <jk...@jkingweb.ca> wrote in message news:op.utpribw4tiq...@odin > On Sat, 09 May 2009 14:37:56 -0400, Igor Tandetnik > <itandet...@mvps.org> wrote: > >> You have two options. You can have an AFTER INSERT trigger that >> updates the freshly inserted record with your desired values. Or, >> you can have a BEFORE INSERT trigger that inserts the values you >> want, then does SELECT RAISE(IGNORE); to suppress inserting the >> original record (one that caused the trigger to run in the first >> place). > > Could he not also use an INSTEAD OF trigger, negating the need for > RAISE(IGNORE)?
I haven't tried it myself, but the documentation seems to suggest that INSTEAD OF triggers can only be created on views. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
