Defines the parameter columns available within the selected component-type table. If the attributes used with the blocks inside the drawing have the same name as a column, the attributes are updated automatically whenever the database table is updated.
Add
Adds a new column to the selected table. Up to 150 columns can be added. Opens the Database Column Modification dialog box.
You can have up to 255 columns in a Microsoft Access database table, but some tables have columns that are being used by Access.
Table Name |
Columns Used by P&ID Program |
Available Additional Columns |
---|---|---|
Components-Instruments |
30 |
225 |
Components-Mechanical |
30 |
225 |
Components-Miscellaneous |
30 |
225 |
Components-Nozzles |
30 |
225 |
Components-Process Lines |
30 |
225 |
Components-Reducers |
30 |
225 |
Components-Valves |
30 |
225 |
Components-Vessels |
30 |
225 |
Project Documents |
24 |
231 |
-
Database table column width
Specifies the number of characters available for the column. The column width is limited to a maximum of 200 characters.
The column width is 255 characters in a Microsoft Access database.
The total width of all columns in a database can not exceed 7500.
-
Database table column name
Specifies the column name. The column name is limited to a maximum of 10 characters. Valid characters are alpha-numeric, underscore, and dash. The first letter of the name must be alpha-numeric. The software internally adds an underscore to the end of the name to avoid names that might be SQL keywords.
-
CEdit dialog name
Specifies the name that appears when a component is selected for editing using Edit . The name is limited to a maximum of 25 characters. For more information, see Edit.
Edit
Changes the properties of the selected column.
Delete
Deletes the selected column.
Specification columns
If added, the following columns are updated from the specification being used.
General Spec Information
Column Name |
Spec Description |
---|---|
WgtFactor |
Weight Factor |
MeasBore |
Measure Bore |
FileLib |
LibrarySubDirectory |
Rating |
NominalRating |
SpecTemp |
Temperature |
SpecPress |
Pressure |
FlgFace |
FlangeFace |
MatPipe |
MaterialPipe |
MatForge |
MaterialForging |
MatFit |
MaterialFitting |
MatGasket |
MaterialGasket |
MatStud |
MaterialStud |
MatBolt |
MaterialBolt |
ExcSize |
ExcludeSizes |
SpecRev |
Revision |
DBFile |
DataBaseCodes |
Component Information
Column Name |
Spec Description |
---|---|
SubDir |
DataFileSubDirectory |
FileName |
DataFileName |
StartSize |
StartSize |
EndSize |
EndSize |
Tag |
ComponentTag |
ShortDesc |
ShortDescription |
LongDesc |
LongDescription |
DBCode |
DatabaseIndex |
BOMSort |
BOMSortSequence |
PrgmCode |
ProgramCode |
CompOpt |
OptionalComponent |
CompNote |
Note |