Displaying progress records by sorting using any one attribute

progress-4gl openedge
sajid shaikh picture sajid shaikh · Sep 8, 2011 · Viewed 7.4k times · Source

Displaying progress records by sorting using any one attribute. I am new to progress so I want to know that how records in table can be displayed according to sorting on one attribute.

Answer

Tom Bascom picture Tom Bascom · Sep 8, 2011

You use the BY phrase like so:

for each customer no-lock where customer.custNum > 100 BY customer.name:
  display customer.custNum customer.name.
end.

Keep in mind that selection and sorting are two different things -- the WHERE clause specifies selection (and in the absence of BY specifies the sort order), the BY specifies sorting.

BY will influence index selection only if there is a tie between two or more possibilities in the WHERE clause.

If the BY order does not match the WHERE order client side sorting may cause a significant performance penalty. (You can compile with XREF to see what indexes are being used and how well they match your desires.)

Related questions

How to get table schema from Progress database via odbc

I have a linked server set up between sql 2008 and a Progress OpenEdge 10.1b server. How do I get the table schemas?

Read More
How to get Current Time in Progress (OpenEdge)

I am coding in Progress (aka OpenEdge ABL). I have a variable that holds a time and I want to figure out if it is greater than the current time. But I cannot find anything in the documentation I've read …

Read More
How do I do HTTP GET and POST in Progress/OpenEdge ABL?

The Progress docs spill plenty of ink on SOAP, but I'm having trouble finding the example for a simple HTTP GET/POST with Progress ABL. How do I GET and POST strings to/from a URL? Can the URL be …

Read More