Monday, 5 September 2011

Sysbase Advantage Database - Using triggers to keep a history

I recently wrote an article about how to use triggers to keep a history of changes made to database records. This is very useful is you want to keep a trail of record changes for example I have used this to keep a trial of stock and where stock has moved from and to, also keeping a history of what has happened to a customer's order. I think most commercial databases would benefit from doing this and because it is done at  the database end it means that once it is done it will always keep a history rather than writing logging into software applications. Click here to go to the article.