Icon View Incident Report

Minor Minor
Reported By: Connie McBride
Reported On: 6/17/2005
For: Version 4.21 Build 4
# 2080 Adding a Descending Index Via TDBISAMTable.AddIndex Method Using Only ixDescending Option Incorrect

Adding an index via the TDBISAMTable.AddIndex method using the ixDescending index option results in an index that cannot be used for the following SQL ORDER BY to ensure a live result set:

select *
From service
order by custname desc nocase



Comments Comments and Workarounds
The problem was that only specifying the ixDescending option without specifying the descending fields also resulted in an index without the appropriate entries for the descending fields, thus the SQL optimizer was ignoring it when determining whether to use it for the ORDER BY.


Resolution Resolution
Fixed Problem on 6/18/2005 in version 4.21 build 5


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

Image