Kbase P22631: How to set the SORT BY clause in the Query of an SDO.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2003 |
|
Status: Unverified
GOAL:
How to set the SORT option in the Query of an SDO.
FACT(s) (Environment):
Progress 9.x
FIX:
You can affect SDO's "SORT BY" Clause by invoking a DYNAMIC-FUNCTION in the SDO.
In the below example "h_dcustomer" is the handle to the SDO from the main window.
Syntax;
DYNAMIC-FUNCTION('setQuerySort':U IN h_dcustomer,
INPUT pcWhere /* CHARACTER */).
Sample Syntax;
DYNAMIC-FUNCTION('setQuerySort':U IN h_dcustomer,
INPUT "BY CreditLimit").
Sample Syntax(With the DESENDING clause);
DYNAMIC-FUNCTION('setQuerySort':U IN h_dcustomer,
INPUT "BY CreditLimit DESENDING ").
Sample Syntax(Variable Value);
Define Variable varvalue as Character no-undo.
Assign varvalue = "BY " + "CreditLimit".
DYNAMIC-FUNCTION('setQuerySort':U IN h_dcustomer,
INPUT varvalue ).