conversion error from string "BLOB"

[Sergio Gonzalez]

Hello there!.
I'm having this problem:

I have this BLOB Field:

LABEL_DESC BLOB SUB_TYPE 1 SEGMENT SIZE 20 CHARACTER SET WIN1252
DEFAULT '',

And I'm assigning it with code like this:

>>>>>>>>>>>>>>>>>>>>

procedure TfrmArticulos.DBEdit8Exit(Sender: TObject);
begin

with dm.Articulos do begin

if FindField( 'Label_Desc' ).AsString = '' then begin

Edit;
FindField( 'Label_Desc' ).AsString := DBEdit4.Text + ' ' +
DBEdit8.Text;
Post;

end;

end;

end;

>>>>>>>>>>>>>>>>

When I Insert a new record and Post it I get this message:

'conversion error from string "BLOB"'

What I'm doing wrong?

Thanks!!

[Craig Stuntz [TeamB]]

In article <3e21...@newsgroups.borland.com>, s...@sion.com says...

>
> When I Insert a new record and Post it I get this message:
>
> 'conversion error from string "BLOB"'
>
> What I'm doing wrong?
>

Generally it means you've written SQL like:

UPDATE MYTABLE
SET SOME_BLOB_FIELD = 'Foo'
WHERE ID = 1000;

You can't assign a literal constant string to a Blob column in SQL;
you must use a parameterized query.

HTH,

-Craig

--
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer