Icon View Incident Report

Minor Minor
Reported By: Sanford Aranoff
Reported On: 7/3/2005
For: Version 4.21 Build 6
# 2089 SQL 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



Resolution Resolution
Fixed Problem on 7/5/2005 in version 4.21 build 7


Products Affected Products Affected
DBISAM 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

Image