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

TableReplaceRow

Replaces a row in the given table.

Syntax

TableReplaceRow(Table As Table, Row Index As Double, Replacement Row As Double)

Where:

Table is the Table in which to replace the row.

Row Index is the index of the row to replace.

Replacement Row is either a single row array or multiple row array that will replace the row at the specified index. The array must include a header row.

Examples

RuleMeaning
TableReplaceRow(DWLookupCustomers, 2, {"","","";"Bolton Burners","Waltham","USA"})Will replace the second row in the Customers table with the values Bolton Burners, Waltham and USA
TableReplaceRow(DWLookupCustomers, 2, TableRow("Bolton Burners","Waltham","USA"))Does exactly as above but uses the TableRow function to contruct the Replacement array.

Example Data

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance

Example Outcome

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersWalthamUSA
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance

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","Waltham","USA";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France"}


Table of Contents