Icon View Incident Report

Serious Serious
Reported By: Hedley Muscroft
Reported On: 3/11/2009
For: Version 2.02 Build 8
# 2947 CREATE VIEW Statement Can Result in an Incorrect View Definition

I'm using EDB Manager (Unicode) and all my views are broken since updating to 2.02b9.

If I try the following SQL, I get:

ElevateDB Error #700 An error was found in the view at line 1 and column 1 (Expected SELECT, TABLE but instead found create)

In the EDB Manager, it appears that the VIEW definitions now all have "CREATE VIEW view_name AS" inserted before the view definition.

create view view_test as select id from appstatus;
select * from view_test;



Comments Comments
This issue only appears if creating or altering the view with 2.02 Build 8 or higher.


Resolution Resolution
Fixed Problem on 3/11/2009 in version 2.02 build 10


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

Image