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

From: Tiago Rocha <please.see.link.at.signature.for.email.address_at_zaz.com.br>
Date: Fri, 11 Jun 2004 11:57:00 -0300
Message-ID: <mvhjc0l5bvka0i56d98us71rkctfmbvj84_at_4ax.com>


[Quoted] On 10 Jun 2004 14:02:04 -0700, thatsamiam_at_yahoo.com (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 ?

Key-Commit trigger on form level. It allows restricted built-ins. All you need is browse the block and give an error message if anything is not right or commit if everything's right.

hth

-- 
Tiago Rocha
Recife - Brasil
www.diariodastrilhas.cjb.net
Received on Fri Jun 11 2004 - 16:57:00 CEST

Original text of this message