Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Need data items w/ equal codes but different types

Need data items w/ equal codes but different types

Need data items w/ equal codes but different types

Using PD

While trying to map an existing database into a CDM I need to establish data items with different types but identical codes: Let E1 and E2 be entities, and E1 shall get an attribute with name/code CODE and type VA10, while E2 has a CODE with VA20. Do not forget: it's no new model, so renaming data items or changing data types is not an option.

PD will not let me a second data item with the same name/code, and if I try to define the second attribute named code, it identifies it with the first one and changes the data type of the code item defined first to the one specified to the second item. Example: I define an attribute "code" with type VA10 for E1; then I go to E2'a attributes and add an attribute "code" with type VA20: promptly the data type of E1's code attribute changes from VA10 to VA20. It's a mean trap if you are not aware of this fact, since there's no warning or information in this case, and I think this the least one to be expected.

Is there ANY way to work around this problem?

Note, that in the existing PD6 CDM, the ARE lots of equally named data items with different data types, and I can import this model into PD9 (of course, though it was successfully checked in PD6, glorious PD9 reports >60 errors after the import, since it is unable to translate the join conditions correctly, but that's another sad case with PD9).

I must admit, that PD9 in my eyes is a piece of crap (so they say in english, don't they?), and I begin to hate it...
Ok, in small test models everything seems to work, but if you have a badly migrated PD6-model with 500 entities and 1000 relationships, 500 inheritances, and multiple references from one entity to another (most delicate problem, but that's another sad story), you have to pray with every PDM generation (what foreign key column names does PD9 want to swap today?).

So, is there any way to achive two data items having the same code but different data types?

Any input is appreciated...

TIA, Werner

RE: Need data items w/ equal codes but different types


Sorry for my sillyness - should have read the f... manual! After unchecking Tools/Model Options/Data Items/Unique Code I was able to define a second item with same code and a different type.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close