OBJ Actions
Actions such as QTY and LAST_PAGE can be specified to return data on the query.Actions include:
| Action | Description |
|---|---|
| OPEN / START | Run the Query and place the row pointer before the first row |
| FIRST | Move the row pointer to the first row |
| LAST | Move the row pointer to the last row |
| PREVIOUS | Move the row pointer to the previous row |
| NEXT | Move the row pointer to the next row |
| END | Move the row pointer after the last row |
| ROW / CACHE_ROW | Return the row pointer value |
| QTY / CACHE_QTY | Return the number of items in the cache |
| TOTAL_ROW | Return the current row position across all rows |
| TOTAL_QTY | Return the Total Number of Rows |
| PAGE_NUMBER | Return the current Page Number |
| LAST_PAGE | Return the number of the Last Page |
| PAGE_SIZE | Return the Page Size |
| PAGE_FIRST_ROW | Return the Row number of the first row on the current page |
| PAGE_LAST_ROW | Return the Row number of the last row on the current page |