Page 1 of 1

SQL Error Code 303 - Feature not supported on Blob

Posted: Tue 04 Aug 2009 07:57
by hschlup
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?

Posted: Tue 04 Aug 2009 09:11
by Plash
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.

Posted: Thu 06 Aug 2009 09:19
by hschlup
The problem is that it seems not to work with Unicode when I set asMemo
Herbert

Posted: Fri 07 Aug 2009 07:22
by Plash
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.