Hi


When we create a crystal report with joins, we get the following error :-


the crystal generated SQl is thus:-


SELECT "JOBCOST"."MACHINENO", "MACHINES"."BUILDCODE",
"MACHINES"."SALEPRICE", "JOBCOST"."POMATERIAL"
FROM   "Z:"."JOBCOST" "JOBCOST"
INNER JOIN "Z:"."MACHINES" "MACHINES" ON
JOBCOST"."MACHINENO"="MACHINES"."MACHINENO"

DBISam is complaining at the FROM "Z:"."JOBCOST" line. If we remove this (in
DBYSys) the sql runs fine




Any solutions?


KevanB

Error:

[Crystal]
Failed to retrieve data from database
Details: 42000: [Elevate Software][DBISAM] DBIsam Engine Error 11949 SQL
parsing error - Expected end of statement but instead found . in SELECT SQL
statement at line 1.....

Kevan,

Via email:

This is an issue with the new Crystal and the path separator used in catalog
names.  It appears that they've broken the catalog name handling once again,
so a fix will be needed from Crystal on this.

--
Tim Young
Elevate Software
www.elevatesoft.com