Kbase P22630: How to set the WHERE 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 WHERE option in the Query of an SDO.
FACT(s) (Environment):
Progress 9.x
FIX:
You can affect SDO's "Query Where" 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('setQueryWhere':U IN h_dcustomer,
INPUT pcWhere /* CHARACTER */).
Sample Syntax(Character Value);
DYNAMIC-FUNCTION('setQueryWhere':U IN h_dcustomer,
INPUT "Customer.Country = 'USA'").
Sample Syntax(Integer Value);
DYNAMIC-FUNCTION('setQueryWhere':U IN h_dcustomer,
INPUT "Customer.Custnum > 10").
Sample Syntax(Variable Value);
Define Variable varvalue as Character no-undo.
Assign varvalue = "Customer.Country =" + "'USA'".
DYNAMIC-FUNCTION('setQueryWhere':U IN h_dcustomer,
INPUT varvalue ).