I am using a trigger to maintain some audit information, for example updating row modification time on any insert or update. I now want to extend that mechanism to include other information from my application, for example logged in user name. I can do that by registering new functions to pass the extra information from the application to the trigger.
But I also want to update these tables from the command line, when these functions wont be available. Is there a way to construct the trigger so that I get NULLs instead of errors when a custom function doesnt exist? Or a better way to pass information into the trigger other than functions? Thanks, _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
