Re: Oracle Forms 4.5 Pre-Query Trigger

From: <kskasi_at_hotmail.com>
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

Original text of this message