Re: Oracle Forms 4.5 Pre-Query Trigger

Hi kskasi

Thank, will give a try

Dan

kskasi_at_hotmail.com wrote:

> Hi there
>
> There are few different ways to do it. You could either do what you want in
> a key-entqry or a key-exeqry triggers.
> so your key-entqry trigger might look something like this
>
> ENTER_QUERY;
> INSERT INTO....
>
> The DML statement above will get executed only after the query is
> performed. You can try the same in key-exeqry trigger as well except that
> you should have EXECUE_QUERY instead of ENTER_QUERY. If you strictly wanted
> to do inside a pre-query trigger then you can cheat the form by creating a
> timer and writing your DML statement inside a WHEN-TIMER-EXPIRED trigger.
> Iam not quite sure how well would that work.
>
> Hope that helps
>
> cheers...Kasi
>
> staylor wrote:
>
> > Can anyone be of assistance. We need to log queries made on a specific
> > form.
> >
> > Whilst the Pre / Post Insert / Delete / Update triggers allow DML
> > statements for audit trails, the Pre-Query trigger runs protected and
> > wont allow DML statements or Unresticted built-ins.
> >
> > Any suggestions would be welcome
> >
> > Dan
Received on Thu Aug 24 2000 - 17:14:04 CEST