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

[Quoted] [Quoted] Unfortunately, as a contractor, firing the DBA is not an option. Anyway, They want to have this thing done completely within the forms, so would anyone happen to know a way to identify newly created records? Maybe then I can actually set the database_value properties?

"Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message news:<1054724607.43530_at_news.thyssen.com>...
> "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 - 22:02:22 CEST