Kbase P98595: How do you set the WHERE clause of an SDO using a variable?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/9/2004 |
|
Status: Unverified
GOAL:
How do you set the WHERE clause of an SDO using a variable?
GOAL:
how to change the WHERE clause of an SDO?
FIX:
1. Build your SDO and place in a smartWindow (in this sample an SDO based on sports.order)
2. Uncheck the 'Open query on initialization' instance property of the SDO
3. Override the initializeObject procedure with a code similar to this:
DYNAMIC-FUNCTION('setQueryWhere':U IN h_dtables,
INPUT ('order-date > ' + STRING(varDate)) /* the new criteria */).
DYNAMIC-FUNCTION('openQuery':U IN h_dtables).
RUN SUPER.
/* Code placed here will execute AFTER standard behavior. */
END PROCEDURE.