Board index » delphi » Error: Blob and array types are not supported for compare operations

Error: Blob and array types are not supported for compare operations

I have create a table with the following structure

CREATE TABLE Table1
(
      Blob1  BLOB SUB_TYPE 1 SEGMENT SIZE 80 NOT NULL,
      Blob2  BLOB SUB_TYPE 1 SEGMENT SIZE 80 NOT NULL
)

I also have a dialog where I let the user input text into a TDBMemo for each one and the TDBNavigator.  I am using a TBIDataSet to handle the SQL operations (using the default statements).

When I try to Post the record from the dialog, I get the following error:

"feature is not supported
Blob and array types are not supported for compare operations."

This only occurs when I try to post a record to a DB with two blob fields defined as such.  If my table only has one blob, then it works just fine.

Suggestions?

 

Re:Error: Blob and array types are not supported for compare operations


Quote
"Tom Bont" <TomB...@charter.com> wrote:

>I have create a table with the following structure

>CREATE TABLE Table1
>(
>      Blob1  BLOB SUB_TYPE 1 SEGMENT SIZE 80 NOT NULL,
>      Blob2  BLOB SUB_TYPE 1 SEGMENT SIZE 80 NOT NULL
>)

>I also have a dialog where I let the user input text into a TDBMemo for each one and the TDBNavigator.  I am using a TBIDataSet to handle the SQL operations (using the default statements).

>When I try to Post the record from the dialog, I get the following error:

>"feature is not supported
>Blob and array types are not supported for compare operations."

>This only occurs when I try to post a record to a DB with two blob fields defined as such.  If my table only has one blob, then it works just fine.

>Suggestions?

Update:

I originally had one blob in my table and tested all my code.
I then put the other blobs in via an ALTER TABLE/ADD and that is when things went south.
After much hairpulling, I decided to rebuild the entire structure from the ground up, defining all the blobs at once.

No change to code, compiled, and everything works fine now ...

Other Threads