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

CLEAR_ITEM Built-in

Description

Clears the value from the current text item, regardless of the current cursor position, and changes the text item value to NULL.

Syntax

PROCEDURE CLEAR_ITEM;

Built-in Type restricted procedure

Enter Query Mode yes

CLEAR_ITEM Example

/*

** Built-in: CLEAR_ITEM
** Example: Clear the current item if it does not represent
** the first day of a month.
** Trigger: When-New-Item-Instance
*/

BEGIN
IF TO_CHAR(:Emp.Hiredate,'DD') <> '01' THEN
Clear_Item;
Message('This date must be of the form 01-MON-YY');
END IF;
END;

 


CLEAR_EOL Built-in