Icon View Incident Report

Serious Serious
Reported By: Danny Humphress
Reported On: 5/10/2005
For: Version 4.19 Build 1
# 2045 Multiple Empty Strings in SELECT Column List With ORDER BY On Same Columns Causes Error

Please try the following query on any table (substitute your own field and table names). This will raise an "Error 10026 Invalid key size specified in index 'Primary' for the table '5040'" message.

SELECT
 SomeField,
 '' AS Sort1,
 '' AS Sort2,
 '' AS Sort3
FROM SomeTable
ORDER BY Sort1, Sort2, Sort3



Resolution Resolution
Fixed Problem on 5/10/2005 in version 4.20 build 1


Products Affected Products Affected
DBISAM Additional Software and Utilities
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