Indicates whether an index is to be maintained on the field. Valid Values 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 Remarks Index is ignored for fields that…
Read more
A time stamp indicating when it was created Remarks 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. Remarks 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. Valid Values 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…
Read more
Index selectivity factors. Index selectivity factors used by Zim’s strategy optimizer. Valid Values A number from 0 to 1.000 (DEFAULT = 1.000) Remarks 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…
Read more
“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. Valid Values 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…
Read more
Indicates whether the field is a virtual field. Valid Values As shown in the table below: Code Meaning No (DEFAULT) The field is a normal field Yes The field is a virtual field Remarks A virtual field’s value is not stored in the database, but is computed dynamically, based on the expression entered into…
Read more
The length of the value in a field or variable. Valid Values Any number Remarks 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)…
Read more
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. Valid Values A 256-character string, containing any character or numeric Valid Values Remarks Non-virtual Fields Default should contain a value expression that will be evaluated and assigned…
Read more
English 
Portuguese