Kbase P51498: Error 3509 not raised as expected in CAN-FIND
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/04/2008 |
|
Status: Verified
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
SYMPTOM(s):
Error 3509 not raised as expected in CAN-FIND
<field> matches multiple fields in <table>. (3509)
Multiple fields qualify for partial field name reference
The compiler fails to recognize the partial field name
The compiler takes the first field in the field order that qualifies
Unexpected behavior occurs for field name reference
CAUSE:
Bug# OE00097063
FIX:
Use fully qualified field names. This cannot be changed at this point since it has been out there doing this from the beginning. When there are multiple fields with the same initial abbreviation, the user should spell them out fully. This same kind of matching happens in dynamic queries and dynamic finds. The reason for the latter is performance, since it takes forever to look for duplicates.