Kbase 19940: Crystal Reports - Error 247 with Inner Joins
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/09/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 7.x
Crystal Reports
All Supported Operating Systems
SYMPTOM(s):
Error 247 when using Inner Joins with Crystal Reports
** Unable to understand after -- "<string>". (247)
[ODBC PROGRESS driver][PROGRESS]** Unable to understand after -- "DECLARE". (247)
Crystal Reports generates SQL code as follows:
SELECT
Customer.Cust-Num, Customer.Country,
Order.Order-num, Order.Ship-Date, Order.PO
FROM
{ oj sports.Customer Customer INNER JOIN sports.Order Order ON
Customer.Cust-Num = Order.Cust-Num}
CAUSE:
The error occurs because Crystal Reports generates incorrect SQL code. Both Merant and Crystal Reports have knowledge base solutions to fix this issue.
FIX:
A workaround for the problem is listed on the Crystal website, article ID: C2003237.
Also, see Data Direct Knowledge Base Solution 25664