Skip to content

Class: CodeValidationTable

Properties | Events | Methods | Index of Classes

Provides a two-column table of validation data for validation lists used with DataDictionary objects.

Hierarchy

cObject > Array > ValidationTable > DescriptionValidationTable > FileValidationTable > CodeValidationTable

Show full hierarchy and direct subclasses

Library: Common Class Library

Package: DDValtbl.pkg

Mixins: cCodeMaintOpen_Mixin

Description

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

Note

If you use a cWebCombo or cWebColumnCombo with a DescriptionValidationTable or CodeValidationTable via a DataDictionary, the default will display the Code descriptions.

See Also

Using Validation Tables