Subject | Re: [firebird-support] Logging data changes |
---|---|
Author | Tim |
Post date | 2006-11-27T12:17:24Z |
Thanks Martijn.
Does the Log Manager handle NULL as described by Ivan?
TY
Tim
At 12:45 27/11/2006, you wrote:
Does the Log Manager handle NULL as described by Ivan?
TY
Tim
At 12:45 27/11/2006, you wrote:
> > We have a requirement from one of our clients to log data changes.[Non-text portions of this message have been removed]
> > (For example, changing client or supplier details, logging stock
> > movements, that kind of thing)
> >
> > I was thinking of using triggers to do this. In other words, on the
> > stock table for example, writing after insert, after update and after
> > delete triggers to track all stock movements including stock sales,
> > who made them, date and time, that kind of thing.
> >
> > Any suggestions? Am I on the right track here?
>
>Yep.
>
>Ever had a look at IBLogManager? www.upscene.com
>
>It can creates these triggers for you and save you a lot of time :)
>
>Martijn Tonies
>Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
>MS SQL Server
>Upscene Productions
><http://www.upscene.com>http://www.upscene.com
>My thoughts:
><http://blog.upscene.com/martijn/>http://blog.upscene.com/martijn/
>Database development questions? Check the forum!
><http://www.databasedevelopmentforum.com>http://www.databasedevelopmentforum.com
>
>