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

steve deno wrote:

> 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

Tell your client's management that almost all of the senior people here think the DBA needs ....

No ... that won't fly ... seriously I would tell that a review of senior developers and DBAs believe triggers are the proper way to implement this functionality and if they have any questions they can feel free to contact the instructor of the Oracle Education Certificate program at the University of Washington who would be happy, on your behalf, to discuss it with them.

Every possible work-around will be more work, more costly, harder to implement and maintain, and more likely to bring discredit on you and them.

Clients hire consultants because they want expertise they don't have themselves. If they won't take the advice [Quoted] they are like an arrested man that refuses advice from his attorney or a patient that ignores their doctor.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
[Quoted] damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)