Field SN

A sequence number for the field. The field’s relative position in the entity set, relationship, or structured document to which it belongs.

Valid Values

A number in the range 0 to 32767

Field Type

The data type of the object’s value.

Valid Values

Char, varchar, alpha, varalpha, numeric, int, longint, vastint, or date

Remarks

For more information about data types, consult the User’s Guide.

See Also

Length, Decimals

Field FieldName

The name assigned to a field or form field.

Valid Values

An 18-character string, containing a valid object name

See Also

ConstName, DDObjectName, DDOwnerName, DirName, DisplayName, DocName, EntName, FormName, MenuName, OwnerName, RelName, RoleName, SetName, UserName, VarName

Field FieldHeading

The heading used to denote the output of a field in a LIST or REPORT command.

Valid Values

Any character string, up to 80 alphanumeric characters

Remarks

If FieldHeading is $Null, the field’s name is used as the heading.

See Also

FieldName

Field ListWidth

The width used to display a field’s value in the output of a LIST or REPORT command.

Valid Values

Any number. The specified number is the width (in characters) that will be used to output the field’s value. If 0 is specified (DEFAULT), the width is determined at output time. If a negative number is specified, the field will not be output.

Field Decimals

The number of decimal places for numeric fields or variables.

Valid Values

Any integer.

If Decimals is left blank, 0 is used by default.

Remarks

Decimals is used for int, longint, vastint, and numeric data types and is ignored when the data type is date, alpha, varalpha, char, or varchar.

See Also

Length, Type

Field OwnerName

The name of the entity set, relationship, or structured document that owns the subject field; or, the name of the entity set or relationship that owns the subject role.

Valid Values

An 18-character string, containing a valid object name that refers to an already-existing object

See Also

ConstName, DDObjectName, DDOwnerName, DirName, DisplayName, DocName, EntName, FieldName, FormName, MenuName, RelName, RoleName, SetName, UserName, VarName

Field Length

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) of numeric data types. Consult the Zim Client-Server User Guide for more information.

See Also

Type

Field Default

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 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.

en_CAEnglish