Kbase P64668: Error 446 runing a query using OF phrase in 4GL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/08/2009 |
|
Status: Verified
SYMPTOM(s):
Error 446 runing a query using OF phrase in 4GL
** More than one index found for <table> OF <table> -- use WHERE,not OF. (446)
FACT(s) (Environment):
More than one primary-unique index on the table
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
This error occurs when there are two indexes in the table and code cannot decide which of them to use to perform the join operation. The "OF" phrase is just a short-hand for "WHERE indexed-field = value" and it is not intended for all cases.
FIX:
As advised in the error message, use phrase "WHERE" instead of "OF" in order to join two tables. For more information see FOR and FIND statements in "Progress Language Reference".