Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 6 of 6 total |
VIEW Bug in 2.02b9 |
Wed, Mar 11 2009 6:17 AM | Permanent Link |
"Hedley Muscroft" | 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? |
Wed, Mar 11 2009 6:31 AM | Permanent Link |
Tiago Ameller | 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. |
Wed, Mar 11 2009 6:39 AM | Permanent Link |
Tiago Ameller | 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. |
Wed, Mar 11 2009 5:10 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Wed, Mar 11 2009 8:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Hedley,
There's a new 2.02 Build 10 available that fixes this issue. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Mar 12 2009 5:16 AM | Permanent Link |
"Hedley Muscroft" | Works fine - thanks Tim.
|
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |