You just might have the blob column in the where clause. Override the update SQL it derives for you with your own in the
UpdateSQL property only remove the blob column from the wherer clause. This should get rid of the error.

I may need to take a look at the SQL generator and eliminate the inclusion of blob columns from the where clause. Or,
you did do your own where clause and put the comparison of the blob columns in the where clause when you shouldn't
have.

Jason Wharton
www.ibobjects.com

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Dear Friends

With cachedUpdates, after deleting some record that has a field of type
BLOB.
when post:
....
master.applyupdates;
detail.applyupdates;

IB 6/IBO 4.3 yelds this error:
BLOB and array data types are not supported for compare.

This occur only when editing the master-detail, and when some record are
deleted.
In the detail exist a field of type BLOB (memo field).

Please, help me!
My project was stoped because this error!

Thanks in advance.




________________________________________________________________________
___
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.
________________________________________________________________________
___
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Links







----------

Dear Friends

With cachedUpdates, after deleting some record that has a field of type
BLOB.
when post:
....
master.applyupdates;
detail.applyupdates;

IB 6/IBO 4.3 yelds this error:
BLOB and array data types are not supported for compare.

This occur only when editing the master-detail, and when some record are
deleted.
In the detail exist a field of type BLOB (memo field).

Please, help me!
My project was stoped because this error!

Thanks in advance.




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links








[Non-text portions of this message have been removed]



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links