View Incident Report

Serious

Reported By: Roy Jones
Reported On: 9/19/2002
For: Version 3.17 Build 1

# 1232 Joining More Than One Table in Crystal Reports 8 Causes a Syntax Error When Running the Query

I keep getting an ODBC error: DBISAM Engine Error (11949 SQL Error) Table name expected after FROM keyword instead found '('

I attempted to create a report using the Report Expert and was trying to link 3 or more tables together when I got the above error. I have also tried adding a third table during the report design process, but to no avail.

Comments and Workarounds

Crystal was adding a bunch of extra parentheses around the joins and DBISAM didn't like that. The workaround was to manually edit the query in Crystal to get rid of the parentheses.

Resolution

Fixed Problem on 9/20/2002 in version 3.18 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap