Icon View Incident Report

Serious Serious
Reported By: Roland Verrinder
Reported On: 9/8/2005
For: Version 4.21 Build 10
# 2106 Live Queries with No Order By Can Select the Incorrect Default Index for Ordering

When using a Descending field with a compound primary index, the order of data returned to a query is correct when requesting a read only dataset but random when requesting a live dataset.

This has only occurred since a recent build and only where an existing table has been altered. In other words, existing tables that have not been altered with the current build behave correctly.

Note: The compond primary index in this case consists of a string; DateTime and Boolean field. The DateTime field is selected as the descending field.


Resolution Resolution
Fixed Problem on 9/20/2005 in version 4.21 build 11


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