Re: Forms 4.5, POST-SELECT trigger

In article <64iov9$k66$1_at_nuacht.iol.ie>, Peter Staunton <pjs_at_iol.ie.spoof> wrote:
>In the Forms 4.5 Online docs, it says that the POST-SELECT trigger can be
>used to perform different actions depending on the number of rows the query
>satisfies. Can anyone tell me how to reference this number of rows?
>
>Many thanks for any help.
>
>Peter
>pjs_at_iol.ie

The on-line documentation says "for example, an action based on the number of records that match the query criteria". Actually, the form never finds out how many rows the query satisfies until the last record has been fetched. And the post-select fires before fetch processing begins.

If you want to find the number of rows, the easiest way is to do a count_query, and trap the message in an on-message trigger. An alternate method might be to use the on-select trigger, capture the block's where clause, and do your own 'Select Count(*) ...'

Regards,
Steve Cosner
http://members.aol.com/stevec5088 Received on Mon Nov 17 1997 - 00:00:00 CET