Re: Validation Question

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 16 Oct 2005 23:17:40 -0700
Message-ID: <1129529860.779942@yasure>

Dereck L. Dietz wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1129517739.858461_at_yasure...
>

>>Dereck L. Dietz wrote:
>>
>>>I'm creating a simple Oracle 6i form which consists of one block

>
> consisting
>

>>>of a three field scrolling area.
>>>
>>>I want to be able to validate the entered data to check for duplicate

>
> values
>

>>>before I commit the data.  I can check for duplicates if they exist in

>
> the
>

>>>database but I can't figure out how to validate new entries that aren't

>
> in
>

>>>the database already and are duplicates.
>>>
>>>Any suggestions on how I can accomplish this?
>>>
>>>Thank you very much.
>>
>>WHEN-VALIDATE-RECORD trigger is one way.
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan_at_x.washington.edu
>>(replace x with u to respond)

>
>
> Yes but I guess what I don't understand is HOW I can validate the data
> that's in the form's scrolling area but hasn't been committed to the
> database yet. I'm not sure how I'd do that.
>
> I can compare a form value against a database value but comparing a form
> value against another form value for some reason has me totally baffled.

See if anything in the form is a violation of the constraint: Query the table(s).

Which seems like a waste to me but it is what you asked.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Oct 17 2005 - 01:17:40 CDT