Icon View Incident Report

Serious Serious
Reported By: Christian Sanggaard
Reported On: 6/8/2006
For: Version 4.24 Build 1
# 2203 Executing a SELECT MAX() Single-Row Query On a Column that is Indexed Causes Lock-Up

The following SQL causes a lock-up of the process.

SELECT MAX(RefNo) FROM SalesEntries WHERE ItemNo='0000000990'



Resolution Resolution
Fixed Problem on 6/12/2006 in version 4.25 build 1


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 ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image