Kbase P9540: SetQuerySort & internal procedure in SDO with no indexed fields gives error 1762
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/22/2003 |
|
Status: Unverified
SYMPTOM(s):
When using SetQuerySort against non indexed fields and then trying to use a user defined internal procedure in the SDO with a query also using no indexed fields in the where clause (i.e. for each by), customer is hitting error 1762
** <fld> is ambiguous with <db>.<table>.<fld> and <db>.<table>.<fld>. (1762)
Sort and error 1762
When used, in any of the where clauses, fields with indexes there is no problem or when defining and using another buffer for same table in the internal procedure then it works
CAUSE:
Bug 20020307-002 fixed in 9.1E.
FIX:
Define a buffer in the internal procedure or use indexed fields