Icon View Incident Report

Serious Serious
Reported By: Mihail Haralampos
Reported On: 10/28/2000
For: Version 2.04 Build 1
# 650 Specifying 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.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 Comments and Workarounds
The workaround is to make sure that your column names are valid in join conditions.

Resolution Resolution
Fixed Problem on 10/29/2000 in version 2.05 build 1