fields
Topic group Related topics Example
Specifies the fields to display in a Browse object, and the field options to apply to each field.
Property of
Browse
Description
The fields is a string with the following the following format:
<field 1> [<field option list 1>] |
<calculated field 1> = <exp1> [<calculated field option list 1>]
[, <field 2> [<field option list 2>] |
<calculated field 2> = <exp1> [<calculated field option list 2>], ...]
The fields are displayed in the order they're listed, and the <field option list> affects the way each field is displayed. The options are as follows:
|
Option |
Description |
|
\<column width> |
The width of the column within which the field appears |
|
\B = <exp 1>, <exp 2> |
RANGE option; forces any value entered in <field 1> to fall within <exp 1> and <exp 2>, inclusive. |
|
\H = <expC> |
HEADER option; causes <expC> to appear above the field column in the browse, replacing the field name |
|
\P = <expC> |
PICTURE option; formats the field according to the picture template <expC> |
|
\V = <condition> |
VALID option; allows a new field value to be entered only when <condition> evaluates to true ERROR MESSAGE option; \E = <expC> causes <expC> to appear when <condition> evaluates to false
|
Calculated fields are read-only and are composed of an assigned field name and an expression that results in the calculated field value, for example:
Commission = Rate * Saleprice
Options for calculated fields affect the way these fields are displayed. These options are as follows:
|
Option |
Description |
|
\<column width> |
The width of the column within which the calculated field is displayed |
|
\H = <expC> |
Causes <expC> to appear above the calculated field column in the browse, replacing the calculated field name |