If I understood you question correctly, where ever you want to validate
your item from DB, create a record group and LOV for that field and
Validate Item to Yes, when user enters the Value to the field and save
it, if doesnot match with DB values it will prompt user to select value
among that LOV values and also user can select correct value from LOV.
Dereck L. Dietz wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1129529860.779942_at_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)
>
> No it's not what I'm trying to ask. I can already query the table for items
> ALREADY in the database.
>
> I want to check the values in my form's scrolling area against other values
> IN the scrolling area, not the database.
Received on Mon Oct 17 2005 - 11:25:41 CDT
