View Incident Report

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

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

Products Affected

DBISAM Additional Software and Utilities
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap