Icon View Incident Report

Minor Minor
Reported By: Dave Harrison
Reported On: 9/18/2007
For: Version 1.05 Build 2
# 2455 Altering a Column's Type in the ElevateDB Manager Causes SQL Compilation Error

I created a new column "First_Name2" and set its column type to CHAR 15. I then dropped the old column "First_Name" and rename "First_Name2" to "First_Name". I then press Ok and EDBMgr complains:

Error #700 An error was found in the statement at line 10 and column 0 (Missing Add, Alter,Drop)"


Comments Comments
This was fixed, but the alteration of columns has changed as of 1.06. Per the release notes:

The ALTER TABLE statement now includes a new ALTER COLUMN AS clause that allows you to completely re-define an existing column. However, it does not allow for renaming the column.

WARNING

With the introduction of the ALTER COLUMN clause, the previous method of using the DROP COLUMN clause followed by the ADD COLUMN clause for the same column name is no longer valid. If you have ALTER TABLE statements that use this method, please be sure to update them to using the ALTER COLUMN clause instead in order to prevent any loss of data.


Resolution Resolution
Fixed Problem on 9/19/2007 in version 1.06 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities

Image