Forms4 POST-SELECT trigger

I am looking for some help with the Forms4.0 POST-SELECT trigger.

I am using Oracle 7.0.15 and Forms 4.0.11 on an IBM RS/6000.

The usage note in the Oracle Forms reference manual states "Use the Post-Select trigger to perform an action based on the outcome of the Select phase of query processing. For example, an action based on the number of records that match the query criteria."

What I would like to do in my Post-Select trigger is to determine if no rows matched the query criteria. For example:

   IF no_rows_found THEN

      ........
   END IF; How do a get a value for no_rows_found?

I've tried the following but this always returns zero: num_rows := get_block_property ( 'BLOCK_NAME', RECORDS_TO_FETCH ) ;

I've also looked into using sql%rowcount, but rowcount is not set until after a fetch. So rowcount is also zero at this point.

Any ideas?

Thanks in advance.
-Mary

Mary Grimley                                   email: mgrimley_at_empros.com
Empros Power Systems Control                   phone: (612) 553-4763
A Division of Siemens EA                       fax: (612) 553-4359
2300 Berkshire Lane North                      Facility Code: PLY067