HP 3000 Manuals

HP ALLBASE/4GL Developer Reference Manual Vol. 1

Validation Tables Screen 

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

Screen Image 


            

Field Descriptions 

Table Name   Enter the name of the validation table (up to 16
characters).

Secured   To protect this table from unauthorized modification, enter Y
after you have completed all the required fields on this screen.  The
entry in this field defaults to N.

If you enter Y, the table can only be modified by a developer who has
signed on to the application under the correct development security code.

Message Name   Enter the name of a message to be displayed if data input
from the screen does not match one of the entries in the table.  The
message type (refer to Messages Screen on page 5-66) 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.

Table Values   Enter a list of up to 51 literals, each of which may
consist of between 1 and 16 characters.  You can use any printable
characters.  Trailing spaces are ignored.  Don't use quotes (") unless
they are part of the literal.

Function Keys 

f1       Field Specs.    Cancels the current screen and displays the
        field specifications data screen.

f2       Ranges  Cancels the current screen and displays the validation
        ranges screen.

f4       Messages  Cancels the current screen and displays the messages
        screen.

Additional Information 

When HP ALLBASE/4GL uses a validation table to check data from a screen
or for reporting, it checks that the value of the data exactly matches
one of the entries in the table.  Trailing spaces are ignored.

HP ALLBASE/4GL stores numeric data (edit code N or S) in right justified
format.  Therefore, HP ALLBASE/4GL will not record a match if you compare
a right justified number against a left justified validation table entry.

MPE/iX 5.0 Documentation