DriveWorks Pro 15: TableGetValue [send feedback...]

TableGetValue

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.

TableGetValue will not retrieve values from the header row.

RowIndex of 1 will refer to the first data row, which is the first row after the header row.

Syntax

TableGetValue(Table As Table, Column Index As Double, Row Index As Double)

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.

Examples

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

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 1Amazon Warriors
Example 2Paris
Example 3United 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.

View all Tech Tips

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:

  1. Go to https://hub.driveworks.co.uk/tech-tips/
  2. Login with your DriveWorks Pro account credentials, if asked
  3. Click the Visit Tech Tips Portal button for access

The portal provides a search facility, start typing the name of the Tech Tip (as indicated above) to display the Tip you require.

Table of Contents