Re: Retrieving Row Count

SUSAN -- There are two basic methods:

(1) Force Forms to query all the records in the block

                by visiting the LAST_RECORD of a block in which you've
                kicked off a query, when at the last record, get the
                value of the :System.Cursor_Record in a variable. That
                will represent the total number of records
                materialized by the query.



            (2) Execute a COUNT_QUERY packaged procedure, trap the


                informational message with an ON-MESSAGE trigger, and
                from the message like 'Query will return 37
                record(s)', strip out the number and store it in a
                variable. 

         Worldwide Support bulletin 100676.081, which any currently
         supported Oracle customer can download or request by phone
         from the Support line, explains how to do (2) above.

--

Steve Muench         Email: smuench_at_oracle.com
Forms Development      CIS: 73404,676
Product Manager
Oracle Corporation