Icon View Incident Report

Serious Serious
Reported By: Adam Brett [Tropical Wholefoods]
Reported On: 9/18/2013
For: Version 2.11 Build 3
# 3887 Views Being Unnecessarily Validated During DROP VIEW Execution

Calling "DROP View [ViewName]" fails if the view contains an error such as a reference to a field in a table which no longer exists.

Run the following script:

SCRIPT
BEGIN

 EXECUTE IMMEDIATE
 ' CREATE TABLE "Activities"
   (
   "ID" INTEGER NOT NULL,
   "PersonID" INTEGER,
   "Name" VARCHAR(100) COLLATE "ANSI",
   CONSTRAINT "PrimaryKey" PRIMARY KEY ("ID")
   ) ';

EXECUTE IMMEDIATE
' CREATE VIEW A_NameList as
  SELECT
      PersonID,
      LIST(Name) as NameList
    FROM Activities
    GROUP BY PersonID
    ORDER BY PersonID ';

EXECUTE IMMEDIATE
 ' ALTER TABLE Activities
   RENAME COLUMN PersonID TO AuthorID ' ;
END;

Now use the EDBMgr IDE to open the view 
A_NameList, you will receive an error message "Field 
PersonID does not exist"

Now Run the following script

SCRIPT
BEGIN

EXECUTE IMMEDIATE
 ' DROP VIEW A_NameList ';

EXECUTE IMMEDIATE
  ' DROP TABLE Activities ';

END

You will receive an error message again. It is possible
to ALTER the view to remove the incorrect field, but 
not to drop it.



Resolution Resolution
Fixed Problem on 9/29/2013 in version 2.14 build 1


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 LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image