SQL Error Code 303 - Feature not supported on Blob

hschlup · Post by **hschlup** » Tue 04 Aug 2009 07:57

Dear all
I'm using Datasnap and I try to use your components with Unicode and Firebird.
Now my first try to save data with a Blob Field I get following Error Message

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

Can you tell me what this means? Does this message come from your components?

Plash · Post by **Plash** » Tue 04 Aug 2009 09:11

This error can occur if you use ftString parameter for inserting into a BLOB column.

You should set DataType of parameter to ftBlob. Or assign value to the parameter using its AsBlob or AsMemo properties.

hschlup · Post by **hschlup** » Thu 06 Aug 2009 09:19

The problem is that it seems not to work with Unicode when I set asMemo
Herbert

Plash · Post by **Plash** » Fri 07 Aug 2009 07:22

Unicode is supported when DataType of the parameter is ftWideMemo. You can use the following code:

Code: Select all

IBCQuery.ParamByName('a').DataType := ftWideMemo;
IBCQuery.ParamByName('a').Value := 'Value';

You can also set the UnicodeMemoParameters global variable from the IBC unit to True. In this case you can use AsMemo for unicode data.