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

SYSTEM.CURSOR_VALUE System Variable

Syntax

SYSTEM.CURSOR_VALUE

Description

SYSTEM.CURSOR_VALUE represents the value of the item where the cursor is located. The value is always a character string.

Usage Notes

Be aware that in triggers where the current navigation unit is not the item, such as Pre-Record , and Pre-Block triggers, SYSTEM.CURSOR_VALUE will contain the value of the item navigated from, rather than the value of the item navigated to.

SYSTEM.CURSOR_VALUE Restrictions

  • Avoid using SYSTEM.CURSOR_VALUE in Pre-Form and Post-Form triggers, where the value of SYSTEM.CURSOR_VALUE is NULL.
  • SYSTEM.CURSOR_VALUE Examples

    Assume that you want to create a user-defined procedure that takes the value of the item where the cursor is located, multiplies the value by a constant, and then reads the modified value into the same item. The following user-defined procedure uses the COPY Built-in to perform this function.

    PROCEDURE CALC_VALUE IS
    new_value NUMBER;
    BEGIN
    new_value := TO_NUMBER(:System.Cursor_Value) * .06;
    Copy(TO_CHAR(new_value), :System.Cursor_Item);
    END;