szsani wrote:

>
> Hi all
>
> I get following error on TIBDataset.AppendRecord if my field is BLOB:
>
> " conversion error from string "BLOB" "
> Result is same when I try with IBConsole or IBAccess.
>
> But some people said on newsgroups Firebird can direcly insert into
> BLOB. I have Firebird 665 on Win2k.
>
> Can anyone help? Thanks in advance.

See if you can run these commands via ISQL:

create table myblobs(acol integer, ablob blob sub_type 1);
insert into myblobs(acol,ablob) values (1,"astring");
select * from myblobs;

You should end up with a successful select of one row.


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further