Re: Forms 4.5 Running Totals

smuench_at_oracle.com (Steven P. Muench) writes:
: Forms is smart about fetching only enough records to show the user the
: initial screenful. Each record fetched fires the POST-QUERY trigger
: once for that row. So, in effect, unless you force all records to be
: queried, while your running total *does* reflect the sum of the
: records that have been fetched so far, it doesn't do what you want
: which is show the sum for the set of records that their current query
: criteria identified, without actually forcing all of the records to be
: queried.

Although it would be nice to have an *easy* way to FORCE all selected records to be fetched. The Records Fetched property allows you specify the maximum numbers of records to fetch, but not the minimum.

Here's an example where the minumum would be useful. We have a form that contains data for 24 hours in a day and selects one day at a time. However, only 12 hours can be displayed on the screen at once due to layout constraints. I'd like a way to tell Forms to fetch all 24 records so the user avoids the delay the first time they click the scrollbar to scroll down to the next 12 hours.

How about a "Minimum Records Fetched" property?

--
Ken Bobey, ISA Corp.                Internet: ken_at_edm.isac.ca
#835 10040-104 Street               TEL: 403-420-8081
Edmonton, AB, Canada T5J 0Z2        FAX: 403-420-8037