Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 11/24/2000
For: Version 2.04 Build 1
# 665 SQL ALTER TABLE Statements Require Repeat of Column Name for REDEFINE Clause

There's a glitch in the OLM ALTER TABLE REDEFINE example:

ALTER TABLE "Names.dat"

Should be corrected to:

ALTER TABLE "Names.dat"
REDEFINE LastName LatName CHAR(30)

I think it would be nice if you could explain the REDEFINE syntax a bit more clear in the Online Manual.


REDEFINE LastName NewName CHAR(30)

Comments Comments and Workarounds
The Online Manual incorrectly stated that repeating the column name was not necessary for the REDEFINE clause. Now the Online Manual is correct, and you may choose to repeat the column name (if you wish to rename it) or not. Note that repeating the same column name will not cause any harm, so this fix will not break any existing SQL statements that use this syntax that was previously required.

Resolution Resolution
Fixed Problem on 11/25/2000 in version 2.05 build 1