Consultor Eletrônico



Kbase P20280: How to dynamically change the WHERE condition in a SmartDataObject
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   16/10/2008
Status: Verified

GOAL:

How to dynamically change the WHERE condition in a SmartDataObject

GOAL:

How to dynamically change the query in a SmartDataObject

FIX:

To dynamically change the where condition of a SmartDataObject the QueryWhere attribute must be set by invoking the setQueryWhere function. For example, assuming that a SmartWindow contains a SmartDataObject pointed to by h_SDO, code similar to the following can be written to change the where condition:

DYNAMIC-FUNCTION('closeQuery' IN h_SDO).
DYNAMIC-FUNCTION('setQueryWhere' IN h_SDO, INPUT "NewWhereConditionGoesHere").
DYNAMIC-FUNCTION('openQuery' IN h_SDO).