Reported By: Samuel Costa Reported On: 9/21/2005 For: Version 4.21 Build 10
# 2111Using a Non-Existent Column in an SQL Query WHERE Clause Does Not Cause an Error i've been running this query with weird results, the following sql deletes all records from the table. But the weird part is that the field year on table two is a field of type Word so an exception should be raised not delete the entire table.
delete from table1
where code in (select code
from table2
where year = A)
ResolutionFixed Problem on 9/26/2005 in version 4.21 build 11
Products AffectedDBISAM Additional Software and Utilities DBISAM ODBC Client-Server DBISAM ODBC Client-Server with Source DBISAM ODBC Standard DBISAM ODBC Standard with Source DBISAM VCL Client-Server DBISAM VCL Client-Server with Source DBISAM VCL Standard DBISAM VCL Standard with Source