Gets the value from the first data row and column of the given table.
Or
Gets the value from the first data row and specified column of the given table.
Or
Gets the value from the specified data row and column of the given table.
RowIndex of 1 will refer to the first data row, which is the first row after the header row.
TableGetValue([Table], [Column Index], [Row Index])
Where:
Table is the Table from which to get the value.
Column Index (optional) is the number of the column from which to retrieve the value. By default this will be the first column.
Row Index (optional) is the number of the data row from which to retrieve the value. By default this will be the first row.
| Rule | Meaning |
|---|---|
| TableGetValue(DWGroupTableCustomers) | Will return the value that exists in the Customers table at column 1, data row 1. |
| TableGetValue(DWGroupTableCustomers, 2) | Will return the value that exists in the Customers table at column 2, data row 1. |
| TableGetValue(DWGroupTableCustomers, 3, 8) | Will return the value that exists in the Customers table at column 3, data row 8. |
Customers Table
| CustomerName | City | Country |
|---|---|---|
| Amazon Warriors | Paris | France |
| Bolton Burners | Concord | United States |
| Boston Bulls | Hanover | Germany |
| Cambridge Cats | Toulouse | France |
| Dynamo Dynamics | Indiana | United States |
| Eagle Sizzlers | Maine | United States |
| Everso Lucky | Vermont | United States |
| Forty Somethings | Illinois | United States |
| Example 1 | Amazon Warriors |
|---|---|
| Example 2 | Paris |
| Example 3 | United States |
DriveWorks Tech Tips Portal |
Editing Table Data This project shows how to add, edit and delete data from a Simple Table. The methods used in this can be transferred to Group Tables and also SQL Tables. |
DriveWorks Tech Tips Portal is available to DriveWorks Pro customers with an active subscription and support contract. Tech Tips provide cut down projects that highlight specific functionality for faster and more effective learning. To access the portal:
The portal provides a search facility, start typing the name of the Tech Tip (as indicated above) to display the Tip you require. |