Progress 4GL query

[Sheldon]

I have a table say 'Employee' with one single field say 'Name'. There are say 9 records in the table. I need to write a 'for each' query with the help of 'where' clause by which i will be able to view/display one selected name (say 'Sheldon' being the 6th record of the 9) at the very first and the rest 8 records(names) in alphabetical order. **Note: Only by constructing a query as such. No concept of temp-tables, buffers. nothing allowed within the 'for each' block other than 'display' statement.

Continue reading...