designer 2000 question
Date: 1995/08/31
Message-ID: <4230st$aed_at_ixnews2.ix.netcom.com>#1/1
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