Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle Forms 6 : Best way to do multiple row validation ?

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@4ax.com>


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 - 09:57:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US