Reported By: Sanford Aranoff Reported On: 7/3/2005 For: Version 4.21 Build 6
# 2089SQL ALTER TABLE IF NOT EXISTS for a Column Still Attempts to Open Table Exclusively The following query throws an exception if the table is opened. This exception makes sense only if the table is to be altered. If, however, the column does exist, there is no reason for the exception.
alter table account add column IF NOT EXISTS StatementDate date
ResolutionFixed Problem on 7/5/2005 in version 4.21 build 7
Products AffectedDBISAM Additional Software and Utilities DBISAM CLX Client-Server DBISAM CLX Client-Server with Source DBISAM CLX Standard DBISAM CLX Standard with Source DBISAM VCL Client-Server DBISAM VCL Client-Server with Source DBISAM VCL Standard DBISAM VCL Standard with Source