Icon View Incident Report

Minor Minor
Reported By: Dave Sellers
Reported On: 7/14/2009
For: Version 4.28 Build 4
# 3035 Referencing an Invalid Column in a JOIN Condition Causes Incorrect Error Message

I certainly feel like I'm going crazy - I just cannot get this to work and I can't see why. I have rewritten this I don't know how many times but even if I remove all the table aliases I get the same or similar error 'table correlation name a in JOIN clause is
invalid in SELECT SQL statement at line 5, column 45'

SELECT b.ocrfilename, b.ocrfilepath, b.ocrpageno, c.acsdoclevel, c.acsdocdate, c.doctype,
d.acddocinfo, c.docsubtype, c.acsdocitemref, c.acsdocinfo, b.ocrxytext, c.acsdref,
i.aciimg_type, p.ocrpagex, p.ocrpagey
FROM ocrcrossref a INNER JOIN imageocrtext b ON b.ocrref = a.ocrref
INNER JOIN fullsubdocumentdetails c ON c.acsdref = a.sdref
INNER JOIN documentdetails d ON d.acddref = a.TLDREF
INNER JOIN imagereferences i ON  i.aciref = a.imglinkref
LEFT JOIN imageocrtextpagedimns p ON p.ocrref = a.ocrref
WHERE TEXTSEARCHjaegerer' IN b.ocrtext)
ORDER BY c.acsdocdate



Comments Comments
The issue was that the i.aciref reference was invalid in the JOIN condition.


Resolution Resolution
Fixed Problem on 7/16/2009 in version 4.28 build 5


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image