View Incident Report

Serious

Reported By: Peter Mora
Reported On: 1/31/2005
For: Version 4.16 Build 1

# 1952 TDBISAMTable TDBISAMIndexDefs Add Method Not Specifying Descending Indexes Properly

I've run into an issue when trying to get a Live dataset from the following table that I created with Dbsys.

MY_TABLE.DAT
-------------------
1. MY_AUTOINC (autoinc)
2. MY_TIMESTAMP (timestamp)

Primary Index: MY_AUTOINC
Secondary Index: MY_TIMESTAMP Descending

The following SQL results in a canned result, but should be a live result.

SELECT * FROM MY_TABLE ORDER BY MY_TIMESTAMP DESC;

Comments and Workarounds

The workaround is to use SQL to create the index or make sure that the ixDescending index option exists in the Options property for the TDBISAMIndexDef object that represents the new index prior to calling the CreateTable or AlterTable method. The problem lies in the fact that the TDBISAMIndexDefs.Add method does not set the ixDescending flag properly for the new TDBISAMIndexDef object when only the descending fields are specified.

Resolution

Fixed Problem on 1/31/2005 in version 4.17 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap