Tracking changes

[mpele]

I have made database and form based upon it. That works fine but I want to track changes made in records. I would like to save in special table information when the changes were made and what is old and what is the new value.

How could I do that? Where should I put trigger and how could I find old and new value of the field?

[DrewJensen]

HSQLDB, the database engine used by a default Base database allows you to create triggers. These triggers implement a defined interface and must be written in Jave. The HSQLDB documentation includes an example trigger that includes the code to to create an audit trail. You can find information on this at the http://hsqldb.org

One thing to keep in mind is that a default Base database does not support user accounts at the database engine. So every user will be logged on as 'SA'. If you want to track users then you will need to create your own user table, and validate your own logon. Then pass this information to your tirgger, as the built in function USER will not be of use to you for this.

Drew
_________________
Blog - http://baseanswers.spaces.live.com/

[tcamdg]

Is there a concrete example or tutorial someone could point to for making a simple audit trigger?

I tried looking through the HSQLDB docs, but couldn't make heads or tails or any audit trigger example...