Stats

  • Locked Locked
  • Replies 0
  • Subscribers 165
  • Views 10029
  • Members are here 0
More Content
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Capture CIS relational database buggy?

eddoh

Well, 
I spent some time to understand how to make it work and I think there is a bug there.

I wanted to link a Diodes table to a procurement table using two fields instead of just the "Part Number" one (reason being that I wanted to have details for a double key relationship - involving not only the Part Number but also the Package.)

So I created a new FKEY field both in the Diodes table and the Procurement tables, set to the same value and in the CIS configration>Setup>Relational database, I set up the following

  • Primary key table name: Diodes
  • Primary key: FKEY
  • Relational table: Procurement

I expected to see the records matching the same FKEY fields, but it does not seem to work.

Looks like the link implemented in the database is always Diodes:Part number -> Procurement:FKEY instead of  Diodes:FKEY-> Procurement:FKEY

In particular here is the test table

Diode:FKEY Diode:Part Number Procurmn:FKEY Procurmn:Part Number Record linked in relation table?
XX YY XX ZZ No (expected yes)
AA XX BB XX No
CC XX XX DD Yes (expected no)
XX EE FF XX No

 think this is a bug, imho. Binding relationship to Part Number of the "Primary key table name" table is actually quite limiting, as you cannot play around tweaking the Part Number field of the main CIS database tables.


Hoping that I got everything right of course. Apologies in advance if I got everything wrong.

Cheers

Cadence Guidelines

Community Guidelines

The Cadence Design Communities support Cadence users and technologists interacting to exchange ideas, news, technical information, and best practices to solve problems and get the most from Cadence technology. The community is open to everyone, and to provide the most value, we require participants to follow our Community Guidelines that facilitate a quality exchange of ideas and information. By accessing, contributing, using or downloading any materials from the site, you agree to be bound by the full Community Guidelines.