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

If I try the following :-

create view view_test as select id from appstatus;

followed by :-

select * from view_test;

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)

I then uninstalled 2.02b9 and re-installed 2.02b8 - same problem!!!

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

I restored to an earlier database (which had not been touched or opened by
2.02b9) and there was no "CREATE VIEW xxx" at the start of the VIEW
definitions and it all works fine.

Any ideas?

Hedley,

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

Same here. It's clearly a bug.

More on it:

If you alter the view in EDBmgr to eliminate the "create view ..." offending code, you get the same: "ALTER VIEW ..." is added before view
definition making it unusable.

Tim: I think you wrote here that in a future version of EDB when creating/altering some item in EDBmgr user could edit generated code before
EDBmgr'll execute it. IMHO it would be a pretty enhacement and a solution for this kind of (historical EDBmgr) bugs.

Hedley,

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

I'll check this out and see what the problem is.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hedley,

There's a new 2.02 Build 10 available that fixes this issue.

--
Tim Young
Elevate Software
www.elevatesoft.com

Works fine - thanks Tim.