Field Specifications

To read or set a certain field value, you can refer to that specific data element as follows:

[<Object>.]<Field>

Item

Description

Object that contains one or more variables.

Objecttypes:

<Field>

Field of one of the types described below.

<Constant> | <Variable> | <Layout field> | <Database field> | <Array element>

Specification for a globally or locally defined container that holds a fixed value.

Specification for a globally or locally defined container that holds a variable value.

Specification for a certain container in the layout control. In this specification may be pointed to a certain
property or (in case of multiple occurrence) to a certain element for the layout control.

The syntax for specifying a layout field is as follows:

<Layout control>['[' <Element position>']'][.<Property> | <Recordname>]

The quotes around brackets in this syntax description mean that these brackets have to be specified literally.
So, these brackets must not be confused with brackets that are not placed between quotes, which indicate that
the surrounded expression is optional.

<Layout control> is the name of the layout control that contains the (sub)value. This may be a paint item in
a screen layout for a form or report as well as a layout specification for a file.

<Element position> is the specification to point to a certain element. This option only applies for graphical
layout controls for which the OccursData property is set for multiple occurrence.

If the layout control is not a listbox or combobox, the horizontal and vertical occurrences are specified the same
way as for normal array elements. In case both the horizontal and the vertical occurrence is set for the layout
control, the horizontal occurrence value is specified as the first dimension (before the comma) and the vertical
occurrence as the second dimension (after the comma).

If multiple occurrence applies to listboxes or comboboxes, the value for the horizontal occurrence is represented
in the first 4 digits in the fieldname parameter. If also the vertical occurrence is set, the next character will be an
underscore(_), which will be followed by 4 digits to indicate the vertical occurrence.

If the horizontal occurrence is not set for listboxes or comboboxes and the value is less than 100, the value for
the vertical occurrence is represented in the first 2 digits in the fieldname parameter. For values euqal to or higher than 100,
there will be 4 digits used to indicate the vertical occurrence value. If the horizontal occurrence is set, the vertical
occurrence value will be placed in the 4(!) digits after the underscore(_) that separates both values.

<Property> is one of the properties that is available for the applicable <Layout control>.

<Recordname> is the name to point to a specific record.

Examples:

fr10lbl := 'invoice nr.'

lay10.fr10lbl := 'test'

display_3.color := 444

rec_10.line1 := ' Number of printed lines ' + sn_linesprinted

edit_0[1].color := 0

lay_1.display_3[1, 3] := 'klmnop'
// The element in print layout control DISPLAY_3
// on layout lay_1 that is on the
// first column and the 3rd row
// gets the value 'klmnop'

Field in the specified database object. Database fields can be fetched through tablequery or free join query
specifications.

Example:

q_users.username

Specification of the element. Array elements are specified between brackets ([]).

Field Specifications

Objecttypes:

Contents