Hi all, I'm quite new to SQLite. I wanted to add an audit trail by using the CREATE TRIGGER statement. My problem is now that I want to log the changes together with the current user and timestamp. The current user is a variable or a index to the user table. Because the TRIGGER statement is a stored procedure I need to find a way to access this variable. Can I use a custom function or variable for this? How is this done? Any other thoughts?
Thanks for your help, André _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users