select *
From service
order by custname desc nocase

---

 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

---

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

---

 Products Affected

---

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