Pane of common properties

Name – name of field;

Table – name of EDB table to which the field belongs;

Owner – name of the owner of the data source component to which the field belongs;

Type – type of field. Displayed names of field types are specific for particular data sources;

Precision – size of field. Interpretation of field precision depends on the type of field;

Scale – scale of field. Interpretation of field scale depends on the type of field;

Special properties

In this pane the properties characteristic for specific types of data sources are collected:

Autoincremental – indication of autoincremental field. For such a field the data source sets the value automatically when adding records to EDB table increasing the value to the specified step for every added record;

Case sensitive – indication of sensitivity of field values to the case of characters when sorting and searching;

Long value – indication of a long value. GIS ObjectLand provides limited possibilities to use long values. Only viewing specified number of characters/ bytes beginning from first character/ byte of field is possible;

Money – indication of a money field. The indication shows that the present decimal field is intended for storing sums of money. It has a fixed size and scale;

Unsigned – indication of an unsigned field. All non-numeric fields are unsigned. For numeric fields the indication denotes that field value should be non-negative.

NULL values – indication of the possibility of setting an empty (NULL) value of field;

Searchable – indication of the possibility of searching records by the value of the present field. It can take the following values:

• yes – search by field values allowed;

• no – search by field values not allowed;

• all except LIKE – search by field values allowed except the relations of matching the pattern;

Primary key – indication showing that the present field is a part of the primary key of EDB table.