Kbase P53286: Error 247 when reading a multiple (3+) table JOIN in Crystal
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 8.3E
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MERANT 3.70 32-BIT Progress SQL-89
FACT(s) (Environment):
MERANT 4.0 32-BIT Progress SQL-89
FACT(s) (Environment):
SEQUELINK 4.0 32-BIT Progress SQL-89
SYMPTOM(s):
Error 247 when reading a multiple (3+) table JOIN in Crystal Reports 9 via SQL-89
** Unable to understand after -- "DECLARE". (247)
Querying 2 or less tables works properly
CAUSE:
JOIN syntax generated by Crystal Reports 9 is not handled by the ODBC driver
FIX:
The following key must be created in the Registry.
Please take a backup of your Registry before making any changes.
1) Create a text file and change the extension to .reg
2) Open the file in NotePad and copy and paste the BOLD text into it:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Crystal Decisions\9.0\Crystal Reports\Database\QueryBuilder\JoinBuilder]
"StarEqualJoinBuilder"="IVSLK13, IVPRO16, IVPRO17"
3) Save the file and run it