André Wetzel <wetzel-tnn6dtsa...@public.gmane.org> wrote: > 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?
Yes, you should be able to use a custom function for this. > How is this done? http://sqlite.org/c3ref/create_function.html -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users