Home Search

DriveWorks Solo 22
TableAppendRow

Send Feedback

TableAppendRow

Appends the given row to the given table, and returns the result.

Syntax

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 (,).

Examples

RuleMeaning
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.

Example Data

Customers Table - for the first and second examples above.

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance

Example Outcome

For the first and second examples above.

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Cheshire StormWarringtonEngland

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

Example Outcome

For the third example above.

CustomerNameCityCountry
Cheshire StormWarringtonEngland

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