# 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

SELECT * FROM new ORDER BY text

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