Re: Forms - checking all values for changes - Including inserts and deletes
Date: Wed, 04 Jun 2003 20:13:59 GMT
Message-ID: <MPG.1947f2e3714ec3319897a5_at_news.la.sbcglobal.net>
sldcrew2k_at_yahoo.com said...
> Hi all,
>
> So my requirement is to create records of all changes made within my
> multiblock form along with who did them etc. I have been instructed
> not to use triggers. Our DBA does not want to manage them.
>
I don't know how your organization is setup, but why does the DBA have to manage the database triggers? If the DBA is reluctant, the schema owner can create their own triggers. Then you can maintain your own triggers.
However, you might ask your DBA to post a message on this NG, explaining why triggers are a bad thing ... then sit back and watch the flames arrive. It might be interesting. I've never actually met a DBA who refuses to implement triggers because it's such a bother. I know a couple of DBAs who are out of work who would be more than happy to take your DBA's place. :)
-- /Karsten DBA > retired > DBAReceived on Wed Jun 04 2003 - 22:13:59 CEST