André Wetzel <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
