Progress
Language Reference
CURRENT-RESULT-ROW Function
Returns the number of the current row of a specified query.
SYNTAX
query-name
A character-string expression that evaluates to the name of a currently open, scrolling query. If query-name does not resolve to the name of a query, or if the query is not open or not scrolling, then the function returns the unknown value (?).
EXAMPLESThe following example uses the QUERY-OFF-END function to determine when to leave the REPEAT loop.
NOTES
- To use the CURRENT-RESULT-ROW function with a query, the query must be associated with a browse widget or you must define the query with the SCROLLING option. For more information on query definitions, see the reference entry for the DEFINE QUERY Statement.
- If the query is empty, CURRENT-RESULT-ROW returns the unknown value (?).
- If the query is positioned before the first record, CURRENT-RESULT-ROW returns the value 1. If the query is positioned beyond the last record, CURRENT-RESULT-ROW returns a value 1 greater than the number of rows in the query result list.
- When possible, Progress performs optimizations for GET LAST and REPOSITION statements. These optimizations make the results list invalid. At that point, CURRENT-RESULT-ROW returns the unknown value (?). These optimizations do not occur if the query is opened with the PRESELECT option or has an associated browse widget.
SEE ALSO
CLOSE QUERY Statement, DEFINE BROWSE Statement,DEFINE QUERY Statement, GET Statement, NUM-RESULTS Function, OPEN QUERY Statement, REPOSITION Statement
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |