Manual

Our 3D CAD supplier models have been moved to 3Dfindit.com, the new visual search engine for 3D CAD, CAE & BIM models.

You can log in there with your existing account of this site.

The content remains free of charge.

5.7.3. Adding/removing database columns 5.7.3.1. Adding database column
Prev	Next

Column name :

Define a name.

Column type:

Select a column type in the list field:

CHAR; VARCHAR; SMALLINT; INT; DECIMAL

Length: For text fields a character string length must be indicated.

Default value: Optional

Create ERP column :

If you want to edit the column in PARTlinkManager in the window Modify column display, set a check-mark (recommended).

Note

The "add columns" process grabs directly onto the database.

In other words, you must be logged in with administration rights!

The demo database PLDBDEMO is based on SQLite and there is no possibility to apply different user.

So that the column is shown in PARTdataManager two requirements must be fulfilled.

Once a column has been successfully added, it is displayed in the Configure dialog box.

In the Modify column display section the respective column has to be set on visible via Visible entry is Yes.

In the columns Variable DB and Variable the assigned column name is shown.

The entry under Variable DB is fixed.

The entry under Variable can be adjusted if needed.

	Note
	You must make sure that exactly this name is continuously used throughout all configurations. (See specifically the next point.)

The column in the desired roles must be entered under Columns to be displayed in PARTadmin.

Note

Please regard, which role you have selected under Roles on the left side. The column display is basically role dependent.

Results in the PARTdataManager

	Note
	In order to get the column to be displayed in the PARTdataManager, you must be logged in with the role assigned to you in PARTadmin

Prev	Up	Next
5.7.3. Adding/removing database columns	Home	5.7.3.2. Removing database column