Kbase P95495: How to find the current record position within a query's results list?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/09/2004 |
|
Status: Unverified
GOAL:
How to find the current record position within a query's results list?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
Use the CURRENT-RESULT-ROW() function which returns the number of the current row of the specified query:
DEFINE QUERY QueryName FOR Customer SCROLLING.
OPEN QUERY QueryName PRESELECT EACH Customer.
REPOSITION QueryName FORWARDS 100.
MESSAGE CURRENT-RESULT-ROW("QueryName")
VIEW-AS ALERT-BOX INFO BUTTONS OK.