DSC_MAIN table

 images\btn_mini.gif  Notation

Summary

This table contains common properties to all descriptors located on diagrams.

Field name

SQL type

Description

DESCINDEX

INTEGER

Unique number of the descriptor.

DESCTYPE

INTEGER

Type of the descriptor (see the DSC_TYPES table).

DESCNAME

CHAR (31)

Name of the descriptor.

OAN

INTEGER

Autonumber of the object this descriptor is connected to if any.

AREA

CHAR (31)

Area of the object this descriptor is connected to if any.

ENAME

CHAR (31)

Name of the object this descriptor is connected to if any.

PICTUREOAN

INTEGER

Autonumber of the diagram, this descriptor is located on. NULL, if the descriptor belongs to the library tool bar.

PICTUREAREA

CHAR (31)

Area of the diagram, this descriptor is located on. NULL, if the descriptor belongs to the library tool bar.

PICTURENAME

CHAR (31)

Name of the diagram, this descriptor is located on. NULL, if the descriptor belongs to the library tool bar.

DIAGRAMDSC INTEGER Number of the diagram descriptor that this descriptor belongs to.
SUBDIAGRAM INTEGER Index of the subdiagram the descriptor belongs to.

GROUPS

INTEGER

The number of groups this descriptor is a member of.

CLICKSENSITIVE

INTEGER

1 if sensitive to mouse clicks, 0 if not.

MOVSYMBOL

INTEGER

Width in pixels of the symbols shown in the library tool bar (read only).

ALARMONSYMBOL

INTEGER

1 if alarms are shown on the symbol, 0 if not.

ALARMONID

INTEGER

1 if alarms are shown on the displayed name, 0 if not.

ALARMONVALUE

INTEGER

1 if alarms are shown on the displayed value, 0 if not.

SHOWNAME

INTEGER

Show the name of the object.

SHOWDESC

INTEGER

Show the description of the object.

SHOWVALUE

INTEGER

Show the value of the object.

SHOWTABLEDESC

INTEGER

Show the table entry names if the object is a table.

SHOWUNIT

INTEGER

Show the unit of the object.

NUMBER_FORMAT

INTEGER

Number of the format to be used to display the value:

1 = digital state/command: “ON”
2
= decimal: 123.45
3
= exponent: 1.2345e+002
4
= binary: 110 (value truncated)
5
= octal: 364 (value truncated)
6
= integer: 123 (value truncated)
7
= hexadecimal: C7B (value truncated)

PREFIXZERO

INTEGER

1 if value is to be prefixed with zeroes, 0 if not.

PREFIXFMT

INTEGER

1 if the value is to be prefixed with the format type (i.e. &H for hexadecimal, &O fir octal), 0 if not.

DRAWFRAME

INTEGER

1 if the frame is to be drawn, 0 if not.

THICKNESS

INTEGER

Thickness in pixels of the frame.

STYLE

INTEGER

Style of the frame. See Microsoft’s documentation of the edge parameter for the DrawEdge() function.

FRAMECOLOR

INTEGER

A number identifying the frame color used.

The number must be given in RGB hexadecimal notation.

BORDER

INTEGER

1 if the border is to be drawn, 0 if not.

BORDERLEFT

INTEGER

Width of the left border.

BORDERTOP

INTEGER

Width of the top border.

BORDERRIGHT

INTEGER

Width of the right border.

BORDERBOTTOM

INTEGER

Width of the bottom border.

BORDERCOLOR

INTEGER

A number identifying the frame color used.

The number must be given in RGB hexadecimal notation.

FONTINDEX

INTEGER

Index of the font used for the descriptor.

HOTX

INTEGER

Horizontal position (left side, center for icons) of the clicksensitive area of the descriptor in IGSS units.

HOTY

INTEGER

Vertical position (top edge, center for icons) of the clicksensitive area of the descriptor in IGSS units.

HOTWIDTH

INTEGER

Width of the clicksensitive area in IGSS units.

HOTHEIGHT

INTEGER

Height of the clicksensitive area in IGSS units.

TEXTLEFT

INTEGER

Left edge of the area used to show the name of the object in IGSS units.

TEXTTOP

INTEGER

Top edge of the area used to show the name of the object in IGSS units.

TEXTWIDTH

INTEGER

Width of the area used to show the name of the object in IGSS units.

TEXTHEIGHT

INTEGER

Height of the area used to show the name of the object in IGSS units.

TETXTRIGHTALIGN

INTEGER

1 if the text is to be rightaligned, 0 if not.

VALUELEFT

INTEGER

Left edge of the area used to show the value of the object in IGSS units.

VALUETOP

INTEGER

Top edge of the area used to show the value of the object in IGSS units.

VALUEWIDTH

INTEGER

Width of the area used to show the value of the object in IGSS units.

VALUEHEIGHT

INTEGER

Height of the area used to show the value of the object in IGSS units.

VALUERIGHTALIGN

INTEGER

1 if the value is to be rightaligned, 0 if not.

DISPATOM

INTEGER

The number of atom whose value is displayed (-1 for table objects means all values).

VALUEFIELDWIDTH

INTEGER

The character width of the displayed value.

COLOR

INTEGER

A number identifying the color used for drawing the descriptor.

The number must be given in RGB hexadecimal notation.

DISPLAYLAYER INTEGER The number of the descriptor layer from 0 - 15.
The layer can be named in the Definition module.
VALUELAYER INTEGER The number of the object value layer from 0 - 7.
The layer can be named in the Definition module.
NAMELAYER INTEGER

The number of the object name/description layer from 0 - 7.
The layer can be named in the Definition module.

 

See Also