Error of validation

From: nick048 <>
Date: 15 Mar 2007 02:27:13 -0700
Message-ID: <>

[Quoted] Hi to All,

[Quoted] I a Form I have 2 Item 'FROM_CODE' AND 'TO_CODE'. Both are VARCHAR2(18) with a format For the Item TO_CODE I have the WHEN-VALIDATE-ITEM trigger:

If (NVL(:TO_CODE,'') < NVL(:FROM_CODE,'')) then begin
DISPLAY_MSG('Code Error', 'To code muts be > From code') ; raise form_trigger_failure;
end if;

For example, if From code = '' and To code = '' the trigger work fine.

If From code = '' and in To code NO VALUE, the trigger don't return the error message.

How can resolve this problem ? I hope in Your help.

Best Regards Received on Thu Mar 15 2007 - 10:27:13 CET

Original text of this message