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)

      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' } }