Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 11 of 11 total
Thread Renaming field in existing table
Sat, May 26 2007 6:39 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PagePage 2 of 2
Jump to Page:  1 2
Image