Reported By: Elevate Software Reported On: 12/14/2000 For: Version 2.05 Build 1
# 686Dropping 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)
ResolutionFixed Problem on 12/14/2000 in version 2.06 build 1