View Incident Report

Minor

Reported By: Dave M
Reported On: 5/17/2006
For: Version 4.24 Build 1

# 2200 Using ALTER TABLE Inside of a Transaction Causes Access Violation

I made the mistake of doing the following. This causes a 11279 access violation in a query c/s 4.23b and in dbsys (both c/s and local). This error shows up in the server log.

START TRANSACTION WITH sometable;
ALTER sometable 
ADD COLUMN if not exists "somecolumn" date;
COMMIT FLUSH

Resolution

Fixed Problem on 5/18/2006 in version 4.25 build 1

Products Affected

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap