Help on Item validation

From: nick048 <>
Date: 13 Mar 2007 06:21:36 -0700
Message-ID: <>

[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:

I have added a trigger WHEN-VALIDATE_ITEM to Item TO_CODE with this code:
DISPLAY_MESSAGE('Code Error', 'From code must be < To code') ; raise form_trigger_failure;
end if;

For example if FROM_CODE = and TO_CODE =, the error message is correctly displayed and the focus return to Item TO_CODE.

If FROM_CODE = 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