Icon View Incident Report

Minor Minor
Reported By: Ricardo Oliveira
Reported On: 11/9/2005
For: Version 4.21 Build 11
# 2133 ALTER TABLE REDEFINE PRIMARY KEY Not Changing Descending Index Fields to Ascending

I have a table with a primary index like this:

Field1; Field2; Field3; Field4; Field5

where Field1, Field2, Field3, and Field4 are set as descending fields.

I wanted to remove Field2 from descending fields so I ran the following query. The problem is that Field2 is not removed from descending fields.

Alter Table Table1 Redefine UNIQUE  Primary Key (Field1 desc, Field2 
asc, Field3 desc, Field4 desc, Field5 asc) Compress NONE



Comments Comments and Workarounds
The workaround is to use drop the index and then re-add it using two separate ALTER TABLE statements.


Resolution Resolution
Fixed Problem on 11/13/2005 in version 4.22 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

Image