Kbase P5796: ADM2: How to know the number of records in an SDO
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/11/2002 |
|
Status: Unverified
GOAL:
ADM2: How to know the number of records in an SDO
FIX:
An example to get the number of records in a SDO is by using the function getLastRowNum. This function returns the number of rows in a browse, or the number of the last row in a browse only when it has been reached.
It means that if you have just opened the query and have just some few batches, getLastRowNum will return ? (question mark). So you can get to the last row of a query using the fetchLast procedure on the SDO.
Here is the code you can use:
RUN fetchLast IN h_dcust.
MESSAGE DYNAMIC-FUNCTION('getLastRowNum':U IN h_dcust).