Icon View Incident Report

Serious Serious
Reported By: Fernando Dias
Reported On: 6/13/2008
For: Version 2.00 Build 1
# 2661 Altering a Table Immediately After Publishing a Table Causes Error

I'm getting Error #100 when trying to open a cursor after altering a table in a published database:

Error #100 There is an error in the metadata for the table Tbl1

Also, the error only occurs if the table is actuality changed.

SCRIPT
BEGIN
   DECLARE Cur1 CURSOR FOR SQL1;

   EXECUTE IMMEDIATE 'PUBLISH DATABASE TestRepl';
   EXECUTE IMMEDIATE 'ALTER TABLE Tbl1 ALTER COLUMN Name AS VARCHAR(20)';
   PREPARE SQL1 FROM 'SELECT * FROM Tbl1';
   OPEN Cur1;
END



Resolution Resolution
Fixed Problem on 6/15/2008 in version 2.00 build 2


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image