Indicates whether an index is to be maintained on the field.
As shown in the table below:
| Code | Meaning |
| No | (DEFAULT) The field is not to be indexed |
| Yes | The field is to be indexed |
| Unique | The field is to be indexed, and each value found in the field must be unique |
Index is ignored for fields that belong to documents.
A time stamp indicating when it was created
A time stamp indicating when it was created
The name of the database table on the database server, if different than the EntitySet name. RemoteName is normally used when there is a naming incompatibility between Zim and the database server.
The name of the database table on the database server
The output mask used to present the formatted data value of a field in a list, report or output command.
The applicable masking pattern characters depend on the data type (Type) of the field (e.g., char, varchar, alpha, varalpha, numeric, int, longint, vastint, or date).
For a more detailed explanation of mask patterns and their relation to data types, see Masking.
The FieldMask is used automatically unless an explicit mask has been applied:
If FieldMask is $Null, the field will be output without masking unless only an explicitly programmed mask will be used, if provided.
Index selectivity factors. Index selectivity factors used by Zim’s strategy optimizer.
A number from 0 to 1.000 (DEFAULT = 1.000)
The index selectivity factors are relevant for indexed fields only.
Each number represents the fraction of records that you would typically expect to retrieve using an indexed lookup with a particular operator or operators.
BWSel | selectivity factor for BETWEEN |
EQSel | selectivity factor for the equals (=) operator |
LGSel | selectivity factor for all other operators (i.e., less than (<), greater than (>), less than or equals (<=), greater than or equals (>=)) |
Values closer to 0 imply a very selective index, while values closer to 1 imply an index with poor selectivity. A value of 1.000 instructs Zim to use its internal selectivity factors.
“Non-null required” status of a field. Indicates whether a value other than $Null is always required for the field in an ADD or CHANGE command.
As shown in the table below:
Code | Meaning |
No | (DEFAULT) The field need not be assigned a non-null value |
Yes | The field must always be assigned a non-null value, either explicitly or by the field’s default attribute (see Default) |
During an ADD command, if no value is required and none is assigned, the field’s value is set to its specified default value, which may be $Null.
Reqd is not used for fields that belong to documents.
Default
The name of an application directory (Directories); otherwise, the one application directory in which the associated object may exist.
An 18-character string, containing a valid object name
In Directories:
DirName is the name assigned to the directory.
In other Object Dictionary entity sets:
In any entity set, the principal object’s DirName must match the DirName of its owner.
If DirName is left blank, the object may exist in any number of application directories.
In DDDescriptions, DirName is where the object being described may be found.
In DisplayForms, DirName is where the owner-display of the associated form may be found.
ConstName, DDObjectName, DDOwnerName, DisplayName, DocName, EntName, FieldName, FormName, MenuName, OwnerName, RelName, RoleName, SetName, UserName, VarName
Indicates whether the field is a virtual field.
As shown in the table below:
Code | Meaning |
No | (DEFAULT) The field is a normal field |
Yes | The field is a virtual field |
A virtual field’s value is not stored in the database, but is computed dynamically, based on the expression entered into the field’s Default attribute.
A virtual field cannot be of type varchar or varalpha
Default
The length of the value in a field or variable.
Any number
Length is not used, but still required, for int, longint, vastint, and date data types.
For numeric fields that belong to an entity set or relationship maintained by an SQL database engine, Length specifies the precision (number of significant digits) of numeric data types. Consult the Zim Client-Server User Guide for more information.
Type
The default value for a field or form field. The value that a required field or form field will assume if no value is specified by the end-user.
A 256-character string, containing any character or numeric Valid Values
Non-virtual Fields
Default should contain a value expression that will be evaluated and assigned to the field during an ADD command. If no expression is specified, and no value is assigned during an ADD, the field’s value is set to $Null.
Virtual Fields
A value expression that defines the virtual field’s contents must be specified.
Form Fields
If no expression is specified, the null string (“”) is used.
English 
Portuguese