Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Validation Question

Re: Validation Question

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 16 Oct 2005 19:55:39 -0700
Message-ID: <1129517739.858461@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)
Received on Sun Oct 16 2005 - 21:55:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US