TableBreak (DriveWorks Documentation)

TableBreak

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

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.

Rule	Meaning
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 ".

Customers Table

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

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