Subject | Re: [ib-support] journalling |
---|---|
Author | Jason Frey |
Post date | 2002-02-25T00:40:47Z |
> My solution uses AFTER INSERT, AFTER UPDATE and AFTER DELETE triggers,Is there any sort of trigger akin to AFTER FETCH, or some such, for when a
> which call a stored procedure, which inserts a row into an audit
> table. In the case of updates, I insert a row in the audit table for
> each individual column that changes (mostly, only a small subset of
> columns get changed in any one update operation).
person just views a record?
I know, probably a long shot, given the various ways to "view" a record
(Joins, used in other triggers/SPs, etc). But, thought I'd throw the
question out there, just in case.
- Jason