Kbase P19234: RESULTS error: ** More than one index found for OF -- use WHERE,not OF. (446)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/05/2005 |
|
Status: Unverified
SYMPTOM(s):
GUI RESULTS Syntax Errors when trying to open a query.
** More than one index found for <table> OF <table> -- use WHERE,not OF. (446)
** <program> Could not understand line <number>. (196)
CAUSE:
The two involved tables are related by more than one field which makes the query tuning phrase: <table> OF <table> ambiguous and generates the error.
FIX:
Manually edit the table relationship in question and specify the related fields. Follow these steps to edit an existing table relationship in Results using the Table Relationships dialog box:
1. Select a base table.
2. Select a table from the list of related tables.
3. Choose the Edit button. The Join Construction dialog box appears. Use it to redefine the relationship between the current base table and the selected related table. See the "The Join Construction Dialog Box" section for information about defining a table relationship. When you finish redefining the relationship and return to the Table Relationships dialog box, the syntax of the new relationship appears in the Relationship field.
4. Choose OK in the Table Relationships dialog box to write the table relationship modifications to the current QC7 file.