Home Search

DriveWorks Pro 22
TableGetRows

Send Feedback

TableGetRows

Returns a new table with only the specified rows.

Syntax

TableGetRows([Table], [First Row], [Rows to Take])

Where:

Table is the Table from which to get the rows.

First Row is the number of the first row to take.

Rows to Take is the number of rows to retrieve.

Examples

RuleMeaning
TableGetRows(DWGroupTableCustomers, 2, 5)Will return an array from the Customers group table, starting at row 2 and containing 5 rows.

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 Outcome

CustomerNameCityCountry
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianaUnited States
Eagle SizzlersMaineUnited States

DriveWorks will return the table above as an array, which will look like:

Table returned as an Array
{"CustomerName","City","Country";"Bolton Burners","Concord","United States";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France";"Dynamo Dynamics","Indiana","United States";"Eagle Sizzlers","Maine","United States"}

© DriveWorks Ltd 2024 - All rights reserved.
Privacy Policy | Terms & Conditions