Column Setup (Database Table Setup Dialog Box) - CADWorx - Help

CADWorx P&ID

Language
English
Product
CADWorx
Subproduct
P&ID
Search by Category
Help
CAESAR II Version
12
CADWorx Version
20.0 (2020)
CADWorx Structure Version
2020(4.0)

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
(already included by default)

ComponentTag

ShortDesc

ShortDescription

LongDesc

LongDescription

DBCode

DatabaseIndex

BOMSort

BOMSortSequence

PrgmCode

ProgramCode

CompOpt

OptionalComponent

CompNote

Note