Progress
Language Reference


CURRENT-RESULT-ROW Function

Interfaces
OS
SpeedScript
All
All
Yes

Returns the number of the current row of a specified query.

SYNTAX

CURRENT-RESULT-ROW ( query-name ) 

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 (?).

EXAMPLES

The following example uses the QUERY-OFF-END function to determine when to leave the REPEAT loop.

r-resrow.p
DEFINE QUERY cust-query FOR customer SCROLLING.
OPEN QUERY cust-query FOR EACH customer WHERE Country = "USA".

REPEAT:
    GET NEXT cust-query.
    IF QUERY-OFF-END("cust-query") THEN LEAVE.
    DISPLAY CURRENT-RESULT-ROW("cust-query") LABEL "Result Row" 
        Cust-num Name.
END. 

NOTES

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