Reported By: Tim Young Reported On: 2/28/2007 For: Version 1.00 Build 1
# 2233Referencing Invalid Column Names From Tables that Are Not in the FROM Clause Causes AV Including a reference to a column name prefaced with an invalid table name that doesn't exist in the FROM clause of a SELECT statement causes an AV.
SELECT * FROM Types WHERE (TITLES.TITLE_NAME Like 'A%')
Comments and WorkaroundsThe workaround is to make sure that all column references are valid.
ResolutionFixed Problem on 2/28/2007 in version 1.01 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial