Re: Oracle Forms 4.5 Pre-Query Trigger
Date: Thu, 24 Aug 2000 08:49:27 +0930
Message-ID: <39A45BFF.EE66792D_at_hotmail.com>
[Quoted] 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 - 01:19:27 CEST