SELECT _BoxNo FROM BandA WHERE _BoxType = 'M' AND
TEXTSEARCH('AutoClear=True',_Options)

---

 Comments and Workarounds

---

The workaround is to add the BLOB column to the full text index for the table. This problem only happens when the column being searched is a BLOB column and is not part of the full text index for the table.

---

 Resolution

---

Fixed Problem on 3/16/2005 in version 4.19 build 1

---

 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