Reported By: Mihail Haralampos Reported On: 10/28/2000 For: Version 2.04 Build 1
# 650Specifying a Non-Existing Column in an SQL SELECT Join Condition Causes an AV Trying to execute an SQL SELECT statement that contains a join condition with an invalid column will cause an AV.
q.sql.clear;
q.sql.add('select PTYPE, DATE, CATEGORY, ANALYSIS, TOTAL from inout');
q.sql.add('where CATEGORY=EXTRA');
// Replacing the below it will work =) <the quotes>
// q.sql.add('Where CATEGORY="EXTRA"');
q.open; // Access Violation Here
Comments and WorkaroundsThe workaround is to make sure that your column names are valid in join conditions.
ResolutionFixed Problem on 10/29/2000 in version 2.05 build 1