Help on Item validation
Date: 13 Mar 2007 06:21:36 -0700
Message-ID: <1173792096.657799.254620_at_n33g2000cwc.googlegroups.com>
[Quoted] Hi to All,
I my form I have 2 Items: FROM_CODE and TO_CODE.
The items are declared as VARCHAR2(18 BYTE) with this visualization
format:
99.99.99.99.999999
I have added a trigger WHEN-VALIDATE_ITEM to Item TO_CODE with this
code:
If :TO_CODE < :FROM_CODE then
begin
DISPLAY_MESSAGE('Code Error', 'From code must be < To code') ;
raise form_trigger_failure;
end;
end if;
For example if FROM_CODE = 00.00.01.03.071767 and TO_CODE = 00.00.01.03.070064, the error message is correctly displayed and the focus return to Item TO_CODE.
If FROM_CODE = 00.00.01.03.071767 and TO_CODE is null, the trigger pass as valid the null code.
How can resolve this problem ? I hope that someone can help me.
Thank You and Best Regards
Gaetano
Received on Tue Mar 13 2007 - 14:21:36 CET