Icon View Incident Report

Serious Serious
Reported By: Elevate Software
Reported On: 12/14/2000
For: Version 2.05 Build 1
# 686 Dropping and Re-Adding a Column Within the Same SQL ALTER TABLE Causes Invalid Field Error

Dropping and re-adding a column in the same ALTER TABLE statement causes an #10000 "Invalid field definition specified for the field <fieldname> in table <tablename>" error when executing the statement.

ALTER TABLE biolife
DROP notes,
ADD notes Char(30)



Resolution Resolution
Fixed Problem on 12/14/2000 in version 2.06 build 1
Image