DriveWorks Solo 15: TableGetHeaderRow [send feedback...]

TableGetHeaderRow

Gets the header row from the given table, as a data row.

Syntax

TableGetHeaderRow(Table As Table, As Data Row As Boolean)

Where:

Table is the Table from which to get the header row.

As Data Row (optional) is TRUE by default and will return the header row as a data row. If set to FALSE it will return it as a header row.

Examples

RuleMeaning
TableGetHeaderRow(DWLookupCustomers, TRUE)Will return an array comprising of two rows; the first row (header row) containing empty values, the second row (data row) containing the values retrieved from the header row in the Customers table.
TableGetHeaderRow(DWLookupCustomers, FALSE)Will return an array comprising of one row, which will be the header row retrieved from the Customers table.

Example Data

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianaUnited States
Eagle SizzlersMaineUnited States
Everso LuckyVermontUnited States
Forty SomethingsIllinoisUnited States

Example Outcomes

Example 1 - First Row contains blank values, Second Row contains the header names

CustomerNameCityCountry

DriveWorks will return the table above as an array, which will look like:

Example 1 - Table returned as an Array
{"","","";"CustomerName","City","Country"}

Example 2 - Single Data Row contains the header names

CustomerNameCityCountry

DriveWorks will return the table above as an array, which will look like:

Example 2 - Table returned as an Array
{"CustomerName","City","Country"}


Table of Contents