Re: Prevent master record without detail records
Date: Fri, 07 Jan 2000 00:57:10 GMT
Message-ID: <853dl0$nv0$1_at_nnrp1.deja.com>
Dinis,
You can code a PRE-INSERT trigger on your master block to check for
data entered in the detail block and RAISE Form_Trigger_Failure if what
you find does not meet your criteria. This will prevent the insert
from taking place.
Hope this helps,
Paul
In article <852f81$udk$1_at_news.fe.up.pt>,
"Dinis Paes" <dmp_at_gist.fe.up.pt> wrote:
> Hello,
>
> I've a form with two blocks: a master and a detail.
> I'd like to prevent the creation of master records
> for which no detail records were defined.
> What's the best way to achieve this?
>
> We're using:
> Forms [32 Bit] Version 6.0.5.31.0 (Production)
> Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production
>
> Thanks for your time,
>
> Dinis
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jan 07 2000 - 01:57:10 CET