Re: Error of validation

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 15 Mar 2007 08:31:22 -0700
Message-ID: <1173972680.806855_at_bubbleator.drizzle.com>


nick048 wrote:
> Hi to All,
>
> 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

What is the business rule? If there must be a TO_CODE then REQUIRED in the property palette should be "Yes."

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Mar 15 2007 - 16:31:22 CET

Original text of this message