Re: Forms 4.5: Limiting Query Question

You want to filter out some records?

in you post_query trigger :
if available >= 0 then
  raise from_trigger_failure;
end if;

The records that raise an error in post_query are not displayed.

However if you want to filter out a lot of records thinks about writing a "where exists" clause in you default where . Filtering at the server site is most of the times much faster!

Steven C. Kondolf wrote:

> I've got a one-block form where I want to query up a group of records. I
> then have a Post-Query trigger where I do some selects to display some more
> information in control items on each of the queried records. I then do
> some math on these control items to finally calculate "available."
> Everything runs fine as long as I bring up ALL records that match the
> query. However, I only want to display records where "available" is < 0.
Received on Thu Jul 09 1998 - 17:08:47 CDT