Help on Item validation

From: nick048 <nicosia.gaetano_at_moonsoft.it>
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

Original text of this message