Re: designer 2000 question

Sounds like bugs to me. Try adding valid values to the PK attribute or PK column instead of using a domain. This will probably "solve" (or at least workaround) the ERD problems. However, I suspect that the Forms generation problem has to do with its trying to combine the normal lookup processing for duplicate values and the lookup in CG_REF_CODES; probably too confusing for it.

-JJ

 Jeffrey Jacobs & Associates
 Oracle CASE Consulting and Training
 951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 415-571-7092, FAX: 800-665-1379 CompuServe: 76702,456  Internet: jjacobs_at_well.com Internet: jmjacobs_at_ix.netcom.com

In <4230st$aed_at_ixnews2.ix.netcom.com> vinayak_at_ix.netcom.com (Vinayak Kulkarni) writes:
>
>One of the entities in my application has primary key composed of one
>attribute and two foreign key relationships. I wanted to add a domain
>to that attribute, it wouldn't work. I doubleclicked on the entity,
>added domain to the attribute, clicked the OK button, saved the ERD,
>then again I double clicked on the entity the domain had disappeared.
>
>In order to get around this problem, I removed the attribute from the
>primary key, added domain to that attribute, saved the ERD, then I
>double clicked on the entity again and added the attribute back to the
>primary key. This way it retained the domain information, generated
>correct DDL with appropriate check constraint on the column
>corrosponding to the primary key attribute. However when I was
>generating a form based on the table containing the attribute the
>Generator gave a warning "Validation added for primary key" and the
>generated form had erroneous code. The procedure generated to check
>validity of the reference code (cg_ref_codes table), had three
>parameters and the when-validate on the field calls the procedure with
>two parameters only. In addition to this the validation code in the
>POST-QUERY was not generated.
>
>Is this a BUG in DESIGNER 2000, FORMS GENERATOR? If you think that I
 am
>not doing something right, please let me know.
>
>
>THANKS A LOT FOR YOUR HELP
>
>
>
Received on Thu Aug 31 1995 - 00:00:00 CEST