ColumnControls Property
Specifies controls to be used for each column in a Grid Control

Syntax:

ColumnControls {aControlDef1,aControlDef2,...aControlDefN} 

Control Definition Array:

      TEXTBOX

{ cControlType , cDataType , cInputMask , cFormat }

cControlType      = 'TEXTBOX' (Required)

cDataType   = 'CHARACTER' , 'NUMERIC' , 'DATE'  (Required)

cInputMask  = cInputMask (Optional)

cFormat           = cFormat (Optional)

      DATEPICKER

{ cControlType , cControlStyle }

cControlType      = 'DATEPICKER' (Required)

cControlStyle     = 'DROPDOWN' , 'UPDOWN' (Required)

      TIMEPICKER

{ cControlType , cTimeFormat }

cControlType      = 'TIMEPICKER' (Required)

cTimeFormat      = '', _TIMELONG24H, _TIMELONG12H, _TIMESHORT24H, _TIMESHORT12H (Required)

      COMBOBOX

{ cControlType , acItems }

cControlType      'COMBOBOX' (Required)

acItems           (Required)

      SPINNER

{ cControlType , nRangeMin , nRangeMax }

cControlType      'SPINNER' (Required)

nRangeMin   (Required)

nRangeMax   (Required)

      CHECKBOX

{ cControlType , cCheckedLabel , cUnCheckedLabel }

cControlType      'CHECKBOX' (Required)

cCheckedLabel     (Required)

cUnCheckedLabel   (Required)

      Data type for each column will depend control specified.

            NUMERIC TEXTBOX         : NUMERIC

            DATE TEXTBOX            : DATE           

            CHARACTER TEXTBOX : CHARACTER

            SPINNER                 : NUMERIC

            COMBOBOX          : NUMERIC

            CHECKBOX          : LOGICAL

Sample:

      @ 10,10 GRID Grid_1 ;

            WIDTH 620 ;

            HEIGHT 330 ;

            HEADERS {'Column 1','Column 2','Column 3','Column 4',;

                  'Column 5'} ;

            WIDTHS {140,140,140,140,140} ;

            ITEMS aRows ;

EDIT ;

            COLUMNCONTROLS { {'TEXTBOX','NUMERIC','$ 999,999.99'},;

                  {'DATEPICKER','DROPDOWN'} ,;

                  {'COMBOBOX',{'One','Two','Three'}} , ;

{ 'SPINNER' , 1 , 20 } , ;

{ 'CHECKBOX' , 'Yes' , 'No' } }