Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 2 of 2 total |
Renaming a column should rename all references of the column |
Tue, Dec 10 2013 4:53 PM | Permanent Link |
Barry | I have several views that reference the same table and these views use column names.
I can use EDBMgr to rename a column of the table, but when it is finished and I click anywhere on the tree, it gives me an error: "ElevateDB Errror #700 An error was found in the view "MyView" ... the column OldColumn does not exist in MyTable". It keeps doing this until I fix the problem. This can be a PIA. The proper way to rename a column is to find all references to "OldColumnName" and if found in a view, edit these views and comment out the column list and replace it with a "*". I also have to comment out all triggers that reference the old name. I then rename the column in the table and go through and uncomment the views and rename the old column name to the new column name. And the same with the triggers. The procedures and functions also have to be changed. Why can't EDBMgr automatically rename all references of the old column name? (In Views, Stored Procedures Triggers etc.) It would make things so much easier. Barry |
Tue, Dec 17 2013 9:42 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Barry,
<< I have several views that reference the same table and these views use column names. I can use EDBMgr to rename a column of the table, but when it is finished and I click anywhere on the tree, it gives me an error: "ElevateDB Errror #700 An error was found in the view "MyView" ... the column OldColumn does not exist in MyTable". >> I'll see what I can do. EDB does it now with triggers, so it definitely has the capability. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |