[Stackoverflow] [Progress OpenEdge ABL] Is there a Progess abl way of only displaying a certain number of records, i.e. equivalent of rownum in SQL?

Status
Not open for further replies.
F

Felice

Guest
When I am querying the progress database often I just want to see 10 or so records to see what the values are, not the entire table of records. Is there an equivalent of SQL's rownum in Progress abl?

SQL:

Code:
SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number;

Progress ABL:

Code:
FOR EACH table_name NO-LOCK:
    display table_name.column_1, table.name.column_2. 
//just show me 10 records -- how can I do that?
END.

Continue reading...
 
Status
Not open for further replies.
Top