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

Tried that one, It doesn't seem to work. We use Headstart, so all the code is placed in lib's.

Br, Henrik

Luc Bosman skrev i meddelelsen
<8v8p2tgj07u2fis5ea0a2nm78q19d0it8k_at_4ax.com>...
>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_/_ |
> ----------------------------------------------------
Received on Wed Dec 06 2000 - 10:09:37 CET