Home Search

DriveWorks Solo 18
TableBreak

Send Feedback

TableBreak

Breaks the table into two at, or after the row matching the given condition, and returns either the top or bottom half.

Syntax

TableBreak(Table or Table Name As Table, Column Index As Double, Condition As String, Top As Boolean, Include Break Row As Boolean)

Where:

Table or Table Name is the Table to break.

Column Index is the number of the column in which to check for a match.

Condition is the condition that defines the break.

Top will return the top portion of the break, when TRUE. Otherwise it will return the bottom portion when FALSE.

Include Break Row will include the row from which the break starts, when TRUE.

Examples

RuleMeaning
TableBreak(DwLookupCustomers,1,"C*",TRUE,TRUE)Will return an array of the rows from the Table Customers up to the entry beginning C, and will include the row at which the break occurs.

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
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
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","Concord","United States";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France"}