Kbase P90091: ADM2: SDO setQuerySort function retains some of the previously defined sort criteria.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/10/2004 |
|
Status: Unverified
SYMPTOM(s):
setQuerySort function retains some of the previously defined sort criteria.
Consecutive, similar calls to the setQuerySort function result in incorrect sort criteria for the WHERE clause of the SDO query.
First call to setQuerySort applies a sort criteria with fields 'fld1' and 'fld2'.
Second call to setQuerySort applies a sort criteria with just 'fld1'.
Opening the query after the second setQuerySort results in the query still being sorted by 'fld1' and 'fld2'.
CAUSE:
This is a known issue being investigated by development
FIX:
A workaround for this issue is to clear the previously defined sort clause by making an extra call to setQuerySort and passing an empty string to the function:
DYNAMIC-FUNCTION('setQuerySort' IN <SDO_Handle>,'').
DYNAMIC-FUNCTION('setQuerySort' IN <SDO_Handle>,'field1').