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)? -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
