Kbase P36582: Cannot compile or run window containing browse widget when connecting to multiple databases
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/03/2009 |
|
Status: Verified
SYMPTOM(s):
Cannot compile or run window containing browse widget when connecting to multiple databases
Connecting to multiple databases
Table name referenced in browse exists in more than 1 connected database
Errors 425 and 725 occur
Table <table> is in database <db name> and <db name> (425)
Unknown or ambiguous table <table>. (725)
Occurs both when using Query Builder or Freeform Query
FACT(s) (Environment):
Progress 8.x
Progress 9.0x
OpenEdge 10.0x
Windows
CAUSE:
By default, the AppBuilder (UIB in Progress 8.x) does not add the database name to table or field references in the automatically generated code.
FIX:
In Options -> Preferences, check the "Qualify Database Fields with Database Name
" option. This will instruct the code generator to add the database names to the table/field references.