Highest Allowed Value/Lowest Allowed Value Property
Description
Determines the maximum value or minimum value, inclusive, that Oracle Forms allows in the text item.
Applies to text item
Set Oracle Forms
Refer to Built-in
GET_ITEM_PROPERTY
Required/Optional optional
Usage Notes
- The following values are valid for range settings:
- any valid constant
- form item (:block_name.item_name)
- global variable (:GLOBAL.my_global)
- form parameter (:PARAMETER.my_param)
- Oracle Forms evaluates the values in items by data type, as follows:
- ALPHA alphabetical according
to your system's collating sequence
- CHAR alphabetical according to
your system's collating sequence
- DATE chronological
- DATETIME chronological
- EDATE valid European date with a default
of DD/MM/YY,chronological
- INT numerical ascending
- JDATE valid Julian date with a default
of MM/DD/YY, chronological
- LONG any combination of up to 65,534
characters, ascending
- NUMBER numerical ascending
- RNUMBER displays NUMBER
values as right-justified, ascending
- For all items, you can enter dates in either:
- the default format for your NLS_LANG
setting or
- the format you specified as a format mask
- For compatibility with prior releases, a reference to a form item or to
a sequence may be specified with a leading ampersand (&)
instead of a leading colon (:).
- To specify a raw value that begins with a leading ampersand (&)
or a leading colon (:), specify two of them
(that is, && or ::).
Related topics
$$DATE$$ examples
$$DBDATE$$ examples
$$DATETIME$$ examples
$$DBDATETIME$$ examples