PDA

View Full Version : Understanding the results of a SQL query to an SP3D Catalog Table



JCAN
02-09-2010, 02:09 PM
Hi,

I am querying the following table to get information about the Structural CrossSection defined in the SP3D Catalog :o

select * from JDCrossSection

When I executed the query there are two fields
CrossSectionIID and CrossSectionCLSID that could provide more information about the CrossSection but I do not how to "convert" the values of these columns :(

Anybody has an idea on how to convert these values into "understandable" information? :twisted:

OID Type CrossSectionIID CrossSectionCLSID
0000EA83-0000-0000-5D00-4D024C431C04 W {F92D39CB-6BE8-48A6-9AEC-0ED19773B3CA} {BBACD079-5071-4E17-A069-4E60705CD3E7}
0000EA83-0000-0000-5D01-4D024C431C04 W {F92D39CB-6BE8-48A6-9AEC-0ED19773B3CA} {BBACD079-5071-4E17-A069-4E60705CD3E7}

tim
02-09-2010, 04:50 PM
JCAN

What kind of information do you need?
Cross section information exists in the view JSTRUCTCSectDesignProperties and JSTRUCTCrossSection.

IID and CLSID is relation information to Catalog Schema.
I don't think it's useful for end user.