SELECT-ALL( ) method

Selects all rows, or a range of rows, in a query connected to the browse.

Return type:

LOGICAL

Applies to:

BROWSE widget

 

Syntax 

SELECT-ALL ( [ starting-row-table1 , starting-row-table2, ... ending-row-table1, ending-row-table2 ... ] )

starting-row-table1

A variable of type ROWID representing the first row in the first table to select.

starting-row-table2

A variable of type ROWID representing the first row in the second table to select.

ending-row-table1

A variable of type ROWID representing the last row in the first table to select.

ending-row-table2

A variable of type ROWID representing the last row in the second table to select.

If you not specify parameters, the SELECT-ALL method selects all rows.

If you specify the starting row and the ending row, the SELECT-ALL method selects all rows between the starting row and the ending row inclusive.

If the query is a join, a ROWID for each table in the query can be specified for the starting row and the ending row. A maximum of 40 parameters is allowed which allows the user to specify a 20-table join, 20 ROWIDs for the starting row, and 20 ROWIDs for the ending row.