Error of validation
From: nick048 <nicosia.gaetano_at_moonsoft.it>
Date: 15 Mar 2007 02:27:13 -0700
Message-ID: <1173950833.713083.164770_at_o5g2000hsb.googlegroups.com>
[Quoted] Hi to All,
Date: 15 Mar 2007 02:27:13 -0700
Message-ID: <1173950833.713083.164770_at_o5g2000hsb.googlegroups.com>
[Quoted] Hi to All,
[Quoted] I a Form I have 2 Item 'FROM_CODE' AND 'TO_CODE'. Both are VARCHAR2(18) with a format 99.99.99.99.999999. 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;
end if;
For example, if From code = '00.00.01.03.0100000' and To code = '00.00.01.03.001000' the trigger work fine.
If From code = '00.00.01.03.0100000' 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