Re: Forms 4.5 - Removing/hiding records in Post-query ??
Date: Mon, 4 Dec 2000 20:58:37 -0800
Message-ID: <t2pt8gkp2opc55_at_corp.supernews.com>
"Henrik Krievs" <wmhek_at_dffe.dk> wrote in message
news:qaKW5.73$8T.2102_at_news.get2net.dk...
> Hi' NG !
>
> Based on a calculated field (calculated in post-query) - I'd like to
> supress/hide/not show - some off the records in the selected set. How is
> that done ?
>
> I've tried at raise form_trigger_failure in post_query, but it on stops the
> calculation - not the showing of the record.
>
> Any ideas ??
>
> BR, Henrik
Just a guess, and this might fire too often and in cases where you don't want it to, but try it anyway.
On WHEN-NEW-RECORD-INSTANCE, try this:
IF :SYSTEM.LAST_RECORD = 'TRUE' AND
:SYSTEM.RECORD_STATUS = 'QUERY' AND
<TRUE boolean condition for your calculation> THEN
clear_record;
END IF;
-Matt
Received on Tue Dec 05 2000 - 05:58:37 CET