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

RECALCULATE Built-in

Description

Marks the value of the specified formula calculated item (in each record of the block) for recalculation. Typically you would invoke this when the formula (or function or procedure that it invokes) refers to a system variable or Built-in function which now would return a different value.

Note that actual recalculation doesn't happen immediately; it occurs sometime after the item is marked but before the new value of the calculated item is referenced or displayed to the end user. Your application's logic should not depend on recalculation of a calculated item occurring at a specific time.

Syntax

PROCEDURE RECALCULATE
(item_name VARCHAR2);

PROCEDURE RECALCULATE
(item_id Item);

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

item_name 
 
The name you gave the item when you defined it. Datatype is VARCHAR2.
 
item_id 
 
The unique ID Oracle Forms assigned to the item when it created the item. Use the FIND_ITEM Built-in to return the ID to an appropriately typed variable. Datatype is Item.

RECALCULATE Restrictions

You can use the RECALCULATE Built-in to recalculate formula calculated items only; if you specify a summary item (or a non-calculated item) as the argument to RECALCULATE, Oracle Forms will return an error message:

FRM-41379: Cannot recalculate non-formula item <block_name.item_name>.