Re: Forms 6i Question

Dereck L. Dietz wrote:
> Hopefully I have phrased this clearly this time ...
>
> I want to check a scrolling area for entered duplicate values before they
> get posted to the database.
>
> I can check values against the database but I'm at a loss how to go about
> checking for newly entered values which may duplicate each other and don't
> already exist in my database.
>
> Can I use a PL//SQL table/record structure and if so, where would I define
> the table (the new form trigger?) and could I loop through such a table to
> check for a value already existing?
>
> Thanks very much.

You can loop through the uncommitted recoreds in the block.

Look at the NEXT_RECORD and NEXT_ITEM built-ins and look at the CLEAR_ALL_MASTER_DETAILS Program Unit built by Oracle when you create a master-detail relationship in a form. Between the two you should be able to solve the problem.

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