BlobType = ftMemo

rhettp · Post by **rhettp** » Sat 01 Sep 2007 22:26

I've only noticed this lately with 2.10.0.10 02.08.07 IBDAC, but it might have also occured in an earlier version: I'm using a TIBCQuery that is request-live. If the dataset contains any TBlobFields or TMemoFields that has a BlobType of ftMemo, then on Post I receive this error:

Dynamic SQL Error
sql error code = -303
feature is not supported
BLOB and array data types are not supported for move operation

This occurs even if the blob-related TFields have not been edited. The blob type in this instance is a BLOB sub-type 1.

I can work around by setting the BlobType to ftBlob, but I was just curious if this change occured with 2.10, and if there is more to the story. We're using Delphi 5. Thanks -

Rhett Price
[email protected]

Plash · Post by **Plash** » Mon 03 Sep 2007 13:44

We have fixed the problem when not modified BLOB fields are included in update queries. The fix will be included in the next build of IBDAC.
IBDAC does not support the ftMemo data type. You should use the ftBlob type for BLOB fields.