Re: Forms 4.5 - Removing/hiding records in Post-query ??

[Quoted] On Mon, 4 Dec 2000 11:19:06 +0100, "Henrik Krievs" <wmhek_at_dffe.dk> wrote:

>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.

Easy, in the post query trigger do something like

result := your compute;
if result < 100 then

   raise form_trigger_failure;
end if;

I use this method when the where clause become too heavy to maintain or too much costing for the database (like some 'exists' in various tables test).
Are you sure of your coding?

-- 
Luc Bosman
DEV/2000 Software Engineer
Database & Network Administrator
l.bosman_at_wanadoo.be                      ICQ 37011625
http://users.skynet.be/kobukai/
 ---------------------------------------------------- 
|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
 ----------------------------------------------------