Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Validation Question
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
![]() |
![]() |