O
B
J

A
c
t
i
o
n
s

<-- Back to Glossary Items

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 Total Row number of the first row on the current page
PAGE_LAST_ROW Return the Total Row number of the last row on the current page