Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!cs.utexas.edu!samsung!sdd.hp.com!zaphod.mps.ohio-state.edu!uakari.primate.wisc.edu!aplcen!uunet!ns-mx!vaxa.weeg.uiowa.edu!broy
From: broy@vaxa.weeg.uiowa.edu (Barbara Roy)
Newsgroups: comp.databases
Subject: Re: Oracle SQL*FORMS 3.0 and SQL*MENU 5.0 gripe
Message-ID: <2367@ns-mx.uiowa.edu>
Date: 18 Sep 90 14:56:08 GMT
Sender: news@ns-mx.uiowa.edu
Reply-To: broy@vaxa.weeg.uiowa.edu
Distribution: usa
Organization: U of I - Weeg Computing Center
Lines: 26
News-Software: VAX/VMS VNEWS 1.3-4

In article <42@genco.uucp>, you write...
> 
>The folowing comments are based on Forms 3.0.14 for UNIX.  We have been a
>beta site since Jan '90 and have been using the production release version
>for over a month.
>  
>You can create master-detail block triggers on more than one block by first
>creating the master block.  Then for each detail block, use 'default' and
>tie in your master block.  This will allow more than one detail block.  AS
>far as deleting a block, you must create it as a 'default' block to get
>your triggers back.  I don't think it's a bug.. just the nature of Forms 3.0.
> 

Sorry, but in the VMS version of FORMS 3.0.15.2 it does NOT work that way.
I created my master block first using default, followed by 2 detail blocks
as default. The second detail block is completely ignored. Deleting blocks
created as default also does not work. The master-detail procedures are not
deleted with the blocks and are not recreated. When I recreate the blocks and 
then generate the form, I get a 'duplicate key in index' error message when
saving the form. According to Oracle support, these are bugs.


Barbara Roy, Weeg Computing Center, University of Iowa, Iowa City, IA. 52242
Phone: 319-335-5506  
Internet: broy@vaxa.weeg.uiowa.edu     Bitnet: broyva@uiamvs
Disclaimer: My opinions are solely my own and may change daily.