View Incident Report

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 and Workarounds

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

Resolution

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap