Board index » delphi » Blob and array data types are not supported for compare operation

rolf

Delphi Developer
Fri, 20 Feb 2004 15:46:02 GMT

Blob and array data types are not supported for compare operation

Hello All,

I am using Delphi 5 with Interbase 6 and doing the following:

I have a TIBQuery with the UpdateObject property set to a
TIBUpdateSQL object.  The IBQuery references a table which has
several fields including Blobs.  My problem is whenever I insert
or edit a record in the IBQuery, as soon as I call IBQuery.Post
I get an error "feature is not supported, Blob and array data
types are not supported for compare operation"

How can I solve this problem?

 
Team

Delphi Developer
Fri, 20 Feb 2004 22:09:04 GMT

Re:Blob and array data types are not supported for compare operation


You have a Blob or Array column in the where clause.  You can't have that.  If
you also get that on an insert check triggers on the table for the use of a blob
field in a where clause.  InterBase doesn't support comparing two blob or array
fields.

Quote
rolf wrote:

> Hello All,

> I am using Delphi 5 with Interbase 6 and doing the following:

> I have a TIBQuery with the UpdateObject property set to a
> TIBUpdateSQL object.  The IBQuery references a table which has
> several fields including Blobs.  My problem is whenever I insert
> or edit a record in the IBQuery, as soon as I call IBQuery.Post
> I get an error "feature is not supported, Blob and array data
> types are not supported for compare operation"

> How can I solve this problem?

--
Jeff Overcash (TeamB)   I don't think there are any Russians
(Please do not email    And there ain't no Yanks
 me directly unless     Just corporate criminals
 asked.  Thank You)     Playing with tanks.  (Michael Been)

Other Threads

1. Blob and array data types are not supported for compare operation

2. BLOB and array data types are not supported for compare operation

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

4. BLOB and array data types are not supported for move operation

5. BLOB and array data types are not supported...

6. why ADO not support oracle BLOB data type?

7. Invalid Field Type for nchar and nvarchar data types (I am using SQL Server 7.0)

8. MSSQL:Table does not support this operation because it is not uniquely indexed

9. Table does not support this operation because it is not uniquely indexed

10. SQL error: Table does not support this operation because it is not uniquely indexed