Consultor Eletrônico



Kbase P32442: How to automatically reopen a query in an SDO when setQueryWhere is invoked ?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   07/02/2011
Status: Verified

GOAL:

How to automatically reopen a query in an SDO when setQueryWhere is invoked ?

GOAL:

How to make sure an SDO immedately refreshes after setting query where clause ?

FACT(s) (Environment):

Progress 9.x
OpenEdge 10.x
Windows

FIX:

Create an override on the setQueryWhere function in the SDO, for example:

RETURNS LOGICAL
( INPUT pcWhere AS CHARACTER) :
/*------------------------------------------------------------------------------
Purpose: Super Override
Notes:
------------------------------------------------------------------------------*/
DEFINE VARIABLE lReturn AS LOGICAL NO-UNDO.
/* Code placed here will execute PRIOR to standard behavior. */

lReturn = SUPER( INPUT pcWhere ).

IF lReturn THEN openQuery().

RETURN lReturn.
END FUNCTION.