A script-enabled browser is required for this page to function properly.

Precompute Summaries Property

Description

Specifies that the value of any summarized item in a data block is computed before the normal query is issued on the block. Oracle Forms issues a special query that selects all records (in the database) of the summarized item and performs the summary operation (sum, count, etc.) over all the records.

Applies to block

Set programmatically.

Required/Optional Required if the block contains summarized items and the block's Query All Records property is set to No.

Default

No

Usage Notes

When an end user executes a query in a block with Precompute Summaries set to Yes, Oracle Forms fires the Pre-Query trigger (if any) once before it executes the special query. Oracle Forms fires the Pre-Select trigger (if any) twice: once just before executing the special query, and again just before executing the normal query.

Precompute Summaries Restrictions