Re: Help: Form 4.5 application difficulties....
From: Ed Giroux <egg_at_cdrh.fda.gov>
Date: 1997/11/19
Message-ID: <01bcf516$dce1c340$b3259496_at_DRM344.cdrh.fda.gov>#1/1
Date: 1997/11/19
Message-ID: <01bcf516$dce1c340$b3259496_at_DRM344.cdrh.fda.gov>#1/1
You can get the count using either of the following techniques: 1. Use forms45 built in count_query package. This package counts the total number of records which will be retrieved. You can get the value by fetching the block property query_hits: ie hits := get_block_property('Your block',QUERY_HITS) Your next step will be to issue EXECUTE_QUERY to retrieve your data. You will have to trap the message code 40355 to prevent Forms45 displaying the Oracle message for the number of rows to be retrieved.
2. The second method is to execute a select count(*) into hits ... statement.
Either way you'll execute 2 queries. Received on Wed Nov 19 1997 - 00:00:00 CET