Class: CodeValidationTable

cObject
---Array
------ValidationTable
---------DescriptionValidationTable
------------FileValidationTable
---------------CodeValidationTable

This is an object for assignment in DataDictionary objects to database fields with the Field_Value_Table property. It provides both values for insertion into the database and descriptions to explain each value. It draws its data from up to two fields of a central codes database file, by default one named CODEMAST. This file contains, along with the value and description fields (known by default to all objects of this class), a field for type values by which to group value/description records for selection for all the (possibly unrelated) validation fields in an application, and an index that orders the records both for this selection and for their presentation in all the application's objects of this class.

If the Validate_State property is set to False, entries are permitted that are not in the list; in its default True state, it requires an entry that matches one of the existing table items. If the Static_State property is set to False, the list will be loaded every time the table is activated; in its default True state, the object is loaded with its list only once in each session.

To disable sorting of all validation lists:

Set Sort_State of DD_Global_Validation_Prompt_Object to False 

Sample

Object oShip_Table  is a CodeValidationTable
    Set Type_Value        To "SHIPPING"
    Set Allow_Blank_State To TRUE
End_Object   // Ship_Table
:
Class OrderHea_Data_Set is a DataDictionary
    :
    Procedure Construct_Object
        :
        Set Field_Value_Table Field OrderHea.Via to oShip_Table

Using Validation Tables