Icon View Incident Report

Serious Serious
Reported By: David Cornelius
Reported On: 10/14/2008
For: Version 2.02 Build 1
# 2820 Altering a Table Immediately After Publishing Causes a Version Mismatch Error When Table Is Opened

Alter table corrupts meta data of published tables.

EXECUTE IMMEDIATE 'CREATE TABLE abc (ID INTEGER);';
EXECUTE IMMEDIATE 'PUBLISH DATABASE MyDB TABLES abc;';
EXECUTE IMMEDIATE 'ALTER TABLE abc ADD COLUMN FirstName VARCHAR(20);';


After this, the table cannot be opened or altered.

Work around: UNPUBLISH the table before altering, 
then rePUBLISH the table.



Comments Comments
This was supposed to have been fixed in 2.00 Build 2 as part of incident report #2661, but the test application was not set up properly and was not catching this error, so the problem was not fixed.


Resolution Resolution
Fixed Problem on 10/16/2008 in version 2.02 build 2


Products Affected Products Affected
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image