Array data for views

Retrieving values for columns in views is unique because the columns in the SQL statement are mapped to the generic validation columns (e.g. VIEWCOL1, VIEWCOL2, etc). These validation columns are the arguments for ObjProperty.

In this example:

• FSLOOKUP contains LOOKUP_CODE for the name of the view and QUERY_CODE for the name of the query.

  

• FSQUERY contains QUERY_CODE with the contents of the SQL in TEXT_QUERY for the contents of the SQL.

  

• FSVALIDATION contains FIELD_NAME for the generic columns mapped to TEXT_QUERY.