Re: Oracle Forms 6 : Best way to do multiple row validation ?

Sam Iam wrote:

> I often have data blocks where I need to validate columns across
> multiple rows for situations where like a user must rank items & there
> should be no gaps & no duplicates.
>
> What's the best place to put this multi-row validation ?
>
> A lot of the validation triggers seem to be row level & so checking
> other rows is illegal.

Assuming your design ... I'd put a trigger on any block the user could move to from that block to validate the entire block before allowing the move.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)