Reported By: Danny Humphress Reported On: 5/10/2005 For: Version 4.19 Build 1
# 2045Multiple 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
ResolutionFixed Problem on 5/10/2005 in version 4.20 build 1
Products AffectedDBISAM 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