Re: Forms - checking all values for changes - Including inserts and deletes

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Wed, 4 Jun 2003 13:13:33 +0200
Message-ID: <1054724607.43530_at_news.thyssen.com>


[Quoted] "steve deno" <sldcrew2k_at_yahoo.com> schrieb im Newsbeitrag news:8e6b14d8.0306031535.7321c348_at_posting.google.com...
> 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 have
> created the following code to check all items in all blocks, comparing
> the 'DATABASE VALUE' against the current value and sending the changes
> to my stored procedure. It works beautifully when called from a
> pre-commit trigger.

Hi Steve,

I second what Sybrand mentioned.
Lead your DBA to the door and
kick him / her out.

Triggers seem the best solution for your problem.

Greetings,
Guido Received on Wed Jun 04 2003 - 13:13:33 CEST

Original text of this message