Stats

  • State Not Answered
  • Replies 3
  • Subscribers 43
  • Views 1782
  • Members are here 0
More Content

CIS Explorer: relation table filtered always using the Part Number field value.

eddoh

I'd like to view detail information  about a package as a relational table.when clicking on a row describing my part,

In my database I am storing the details in a Packages table, having a key field "Package"
I have set up the relationship table between the main table, which has a matching PACKAGE field, by specifying PACKAGE in the drop down and PACKAGES as relational table.

What happens is that, when I click on a row of the main table, CIS is looking for a matching table in the PACKAGES table using the PART NUMBER value in the filter condition - as I see from the SQL log of my database [i.e. SELECT .... FROM PACKAGES WHERE PACKAGE='NE555' for instance)

I think this is a bug, I wonder if someone has a solution.

Thanks!

  • Jeet
    0

    How much time it takes to load the Package in Relational Table and where is your database (.dbc) database present on server or is configured locally?

    Which version and hotfix of the tool you are using?

  • eddoh
    0 in reply to Jeet

    my dbc is in a local folder, Not sure what you mean by the time question. Once the record is selected, the query to the server (located on a different host) is instantaneous. The connection is via a configured ODBC.
    I am using Orcad X 24.1 P001.

  • eddoh
    0 in reply to eddoh
    eddoh said:
    I have set up the relationship table between the main table, which has a matching PACKAGE field, by specifying PACKAGE in the drop down and PACKAGES as relational table.

    By this, of course, I meant I have set that up in the Orcad:CIS configfuration :Configure database::Relational Database panel, selecting the table holding the part details and choosing its PACKAGE field and specifying PACKAGES as relational table.

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.