Piping Component NPD - Intergraph Smart 3D - Help - Hexagon

Intergraph Smart 3D Catalog

Language
English
Product
Intergraph Smart 3D
Subproduct
Catalog
Search by Category
Help
Smart 3D Version
13.1

Name: Piping Component NPD
Description: Comp NPD1 X NPD2
Type: SQL
Is Recursive: No
Conditional Formatting: No
Design Time Prog ID: SP3DLabelFormatDesigner.RTFLabel
Run Time Prog ID: SP3DLabelsFormat.FormatLabel
Returned Properties:
SQL Query:
SELECT dbo.REPORTConvertNPD('in',pco.PriSizeNPDUnits, pco.PrimarySize) AS 'NPD1',
'in' AS 'NPDUnitType1',
'Piping' AS 'Category',
NULL AS 'BoltDiameter',
dbo.REPORTConvertNPD('in',pco.SecSizeNPDUnits, pco.SecondarySize) AS 'NPD2',
'in' AS 'NPDUnitType2'
FROM xmadefrom rmf
JOIN JDPipeComponent pco on (pco.oid = rmf.oiddestination)
WHERE rmf.oidorigin = ?

SELECT RPTConvertNPD('in',pco.PriSizeNPDUnits, pco.PrimarySize) AS NPD1,
'in' AS NPDUnitType1,
'Piping' AS Category,
NULL AS BoltDiameter,
RPTConvertNPD('in',pco.SecSizeNPDUnits, pco.SecondarySize) AS NPD2,
'in' AS NPDUnitType2
FROM xmadefrom rmf
JOIN JDPipeComponent pco on (pco.oid = rmf.oiddestination)
WHERE rmf.oidorigin = ?