Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 2/27/2007
For: Version 1.00 Build 1
# 2246 Altering a Table and then Trying to Drop it Causes AV or Weird Error Message

The following SQL generates this error:

ElevateDB Error #400 The table t1 already exists

When closing EDB Manager, I got the following Windows error message:

ElevateDB Manager has encountered a problem and needs to close.

And then the following error:

Runtime error 217 at 00541AD2

create table t1
 pkey integer not null,
 constraint pk_t1 primary key (pkey)

create table t2
 pkey integer not null,
 fkey integer,
 constraint pk_t2 primary key (pkey),
 constraint fk_t2 foreign key (fkey) references t1 (pkey)

alter table t2
drop constraint fk_t2

drop table t2  <<< Error

Resolution Resolution
Fixed Problem on 2/28/2007 in version 1.01 build 1

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