Home Search

DriveWorks Pro 21
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], [Column Index], [Condition], [Top], [Include Break Row], [Ignore Whitespace])

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.

Ignore Whitespace (optional) is True to ignore leading/trailing whitespace characters in text strings, in the condition, otherwise False.

Examples

RuleMeaning
TableBreak(DwLookupCustomers,1," C*",TRUE,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. Will remove the whitespace, after the first ".

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"}

Available Operators

This is the list of operators that are available to apply to the Condition argument.

Name of OperatorOperatorExample Condition Argument
Less then<"<900"
Less then or Equal to<="<=900"
Greater then>">900"
Greater then or Equal to>=">=900"
Not Equals<>"<>=900"
Equals= (No Symbol Required)"900"
Like"*""*Single*"
Not Like"<>*""<>*Single*"