TableData - ValidationTable

Returns the validation table's data in a two dimensional variant array

Type: Function
Return Data Type: Variant[][]

Syntax

Function TableData Returns Variant[][]

Call Example

Get TableData to Variant[][]Variable

Description

TableData returns validation table's data in a two dimensional variant array where the first dimension contains data and the second dimension contains the description.

Procedure ShowAllData 
    Integer i iRows
    Variant[][2] vTerms

    Get TableData of Terms_table to vTerms
    Move (SizeOfArray(vTerms)) to iRows
    For i from 0 to (iRows-1)
        Showln   i " Data=" vTerms[i][0] " Description="vTerms[i][1] 
    Loop
End_Procedure

This method was created to make it easy to pass validation data to a Crystal Reports report via CDO.

Procedure OnInitializeReport Handle hoReport
    Handle hoCDOStates hoCDOTerms
    Variant[][2] vStates
    Variant[][2] vTerms

    Get CreateCDO of hoReport "States.ttx" to hoCDOStates
    Get TableData of Customer_State_VT to vStates
    Send ComAddRows of hoCDOStates vStates

    Get CreateCDO of hoReport "Terms.ttx" to hoCDOTerms
    Get TableData of Terms_table to vTerms
    Send ComAddRows of hoCDOTerms vTerms

End_Procedure

Return Value

Returns table data in a variant array:

vData[x][0] = data value vData[x][1] = description value

where x represents one "row" of data