Re: Forms 4.5: Limiting Query Question

From: Charles Jardine <cj10_at_cam.ac.uk>
Date: Fri, 03 Jul 1998 14:50:05 +0100
Message-ID: <359CE18D.2B11_at_cam.ac.uk>


Steven C. Kondolf wrote:
>
> Hi -
>
> 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.
>
> For the life of me, I can't figure out how to accomplish this. I'm pretty
> new to forms and pl/sql in general so I'm hoping it's relatively simple.
> Is there a command I can put in the Post-Query trigger that tests the value
> of the control item "available" and skips to the next record if "available"
> is >= 0?

Yes. If the post-query trigger fails, the record will be skipped. So what
you need is

IF avaiable >= 0 THEN RAISE form_trigger_failure; END IF; Received on Fri Jul 03 1998 - 15:50:05 CEST

Original text of this message