Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 11 to 11 of 11 total |
Renaming field in existing table |
Sat, May 26 2007 6:39 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I don't think this is possible using the EDBManager. We are converting a BDE application to use EDB, and I am taking the opportunity to make some field names more comprehensible. But after creating the new database, copying all data from the BDE version into the EDB version, and only then discovering that I wanted to change one more field name .. Redo the whole process, or write some one-off code that adds a field under the new name, copy the data across from the field with the old name. A hassle. >> I should have a solution for this in the next month or so along with the scripts. The issue was originally inherited from the SQL Standard and the fact that columns tend to be bound to other database objects such as procedures and functions. However, since EDB uses dynamic statement execution in procedures and functions, column name changes in an ALTER TABLE are not an issue and can be put in. -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |