Problems with TEXT BLOB

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
HK
Posts: 12
Joined: Tue 14 Nov 2006 13:30

Problems with TEXT BLOB

Post by HK » Wed 05 Dec 2007 11:35

Hello friends.

I'm using the last version of CoreLab(4.20) in Deplhi 2007 with DBExpress 4. If I try to update or insert a TEXT BLOB on compare of two TEXT fields, the system returns a error message : "Error : Operand Type Clash : varbinary is incompatible with text. ". How to resolve this issue ?

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 05 Dec 2007 15:26

You can take a look at the Pictures demo of DbxSda. It demonstrates how to work with IMAGE fields. Approach for working with TEXT fields is the same.
You can also use TMemoField instead of TBlobField that is used in the Demo. TMemoField is a descendant of TBlobField.

Post Reply