Icon View Incident Report

Minor Minor
Reported By: Ralf Mimoun
Reported On: 7/5/2004
For: Version 4.08 Build 1
# 1779 An SQL SELECT Query With an ORDER BY Clause on a BLOB Column Causes Incorrect Error Message

I started to convert the running projects to DBISAM 4. No problems Ican't solve (had to re-optimize some SQL statements) until I got a strange error message:

DBISAM Engine Error # 12292 Invalid field 'Bemerkung' specified for the index '' in the table '9640'

Well, "9640" is a temporary table, created by DBISAM. I don't feel any urge to define any kind of index for it :) I broke it down to the table you find in the attachment: 2 fields, nil data, _very_ straight forward. Now try


You got a Carl Coyote. It seems that ordering to a memo field is a no-go.

Comments Comments and Workarounds
Ordering an SQL result set by a BLOB column has always been illegal, but the SQL code was not catching this issue with the proper error message. Also, this only applied when naming the BLOB column as a column name, using ORDER BY <Column Number> would result in the proper error message.

Resolution Resolution
Fixed Problem on 7/6/2004 in version 4.09 build 1