Kbase P25900: Error (425) displays a wrong database name in its message
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/02/2005 |
|
Status: Unverified
SYMPTOM(s):
Connecting to three different databases (db1, db2 and db3, for instance) from a Progress session at the same time
Two of the connected databases (db2 and db3) have a table with the same name (table1, for example) defined in their definitions
The remaining database (db1) has a table (e.g.: table1-detail) with a name beginning with the same characters as the name of the common table between the other two databases
Running code that looks like as follows:
FOR EACH table1:
DISPLAY table1.
END.
Progress displays a wrong database name within the error message# 425
Table <table> is in database <db name> and <db name> (425)
Table table1 is in database db1 and db2 (425)
Unknown or ambiguous table <table>. (725)
Unknown or ambiguous table table1. (725)
** <program> Could not understand line <number>. (196)
CAUSE:
The fact that Progress accepts the minimum unique name for a database table and matches that against full table names is causing Progress to display incorrect information when the message in error# 425 is displayed to the user. This is a known issue.
FIX:
Qualify the database table with a database name and the error# 425 will no longer occur. e.g.:
FOR EACH db2.table1:
DISPLAY db2.table1.
END.