Appends the given row to the given table, and returns the result.
TableAppendRow(Table As Table, Collection of Cell values As String)
Where:
Table is the table in which the row is to be added.
Collection of Cell values are the values to add to each cell in the row, in column order and separated with a comma (,).
| Rule | Meaning |
|---|---|
| TableAppendRow(DWGroupTableCustomers, "Cheshire Storm","Warrington","England") | Will append the values Cheshire Storm, Warrington and England to the table Customers. |
| TableAppendRow(DWGroupTableCustomers, CustomerReturn,CityReturn,CountryReturn) | Will append the values from the controls Customer, City and Country to the table Customers. |
| TableAppendRow({"CustomerName","City","Country"}, CustomerReturn,CityReturn,CountryReturn) | Will append the values from the controls Customer, City and Country to the table constructed within the {} brackets. |
Customers Table - for the first and second examples above.
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
For the first and second examples above.
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Cheshire Storm | Warrington | England |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"CustomerName","City","Country";"Amazon Warriors","Paris","France";"Bolton Burners","Concord","United States";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France";"Cheshire Storm","Warrington","England"} |
For the third example above.
| CustomerName | City | Country |
|---|---|---|
| Cheshire Storm | Warrington | England |
DriveWorks will return the table above as an array, which will look like:
| Table returned as an Array |
|---|
| {"CustomerName","City","Country";"Cheshire Storm","Warrington","England"} |