HP 3000 Manuals

Validation Ranges Screen [ HP ALLBASE/4GL Developer Reference Manual Vol. 1 ] MPE/iX 5.0 Documentation


HP ALLBASE/4GL Developer Reference Manual Vol. 1

Validation Ranges Screen 

This screen allows you to define a range of values for use in validating
input data or selecting records for reporting.

Screen Image 

[]
Field Descriptions Range Name Enter the name of the validation range (up to 16 characters). Secured If you wish to protect this validation range from unauthorized modification, enter Y after you have completed the required fields on this screen. The entry in this field defaults to N. If you enter Y, this validation range can only be modified by a developer who has signed on to the application under the correct development security code. Edit Code Enter a code defining the type of data in the range. The edit code defines the method by which HP ALLBASE/4GL checks the range. Refer to Additional Information. The following table lists the available edit codes and their meanings. Code Meaning X Any printable character. A Alphabetic characters only (A to z, extended characters, or space). U Forced uppercase. Same as X edit code, but shifts all lowercase alphabetic characters to uppercase. K Alphanumeric characters only (A to z, 0 to 9, extended characters, and underscore). N Unsigned number (0 to 9, a period ".", or a comma ","). S Signed number. Same as N edit code, but may include + or -. Q Question. Y, y, N, or n only. Any characters beyond the first character in the field are ignored. D Date field. Must be eight characters long. The date may be either MM/DD/YY or DD/MM/YY (depending on the system-wide date format) where MM, DD, and YY represent the month, day, and year respectively. T Date field, defaulting to the current date. Value - From Enter the starting value of the range. Value - To Enter the last value of the range. Number of Decimal Places Enter the number of decimal places allowed in the number if the range is numeric (edit code N or S). Message Name Enter the name of a message to be displayed if data input from the screen falls outside the specified range of values. The message type (refer to Messages Screen) determines how the system reacts if the user enters incorrect data. If you don't enter a message name in this field, the screen processing logic displays a system defined ERROR type message if the user enters incorrect data. Refer to chapter 6 for details of the screen processing logic. Function Keys f1 Field Specs. Cancels the current screen and displays the fields specification screen. f3 Tables Cancels the current screen and displays the validation tables screen. f4 Messages Cancels the current screen and displays the messages screen. Additional Information The edit code for the range determines the method of checking whether a value falls within the range. If the validation range is numeric (that is, the edit code is either N or S), HP ALLBASE/4GL performs the range check by following strict numeric precedence. If the validation range is not numeric, HP ALLBASE/4GL performs the range check on a character by character basis following the standard HP ALLBASE/4GL collating sequence. The order of precedence allocated to characters within a non-numeric range is as follows: Blanks Numeric digits 0 to 9 Alphabetic characters A to z Other characters (punctuation characters) The HP ALLBASE/4GL collating sequence is listed in appendix A.


MPE/iX 5.0 Documentation