i understand what you mean, but think about it for a moment, if the field is
a blob, then why does it care what i pass in, blob means binary means
anything i want to, so if it is a string so what it should just store it as
binary, why does it try and convert it, i can understand if the field is a
string, which is indexed and interbase needs to check and handle it if you
then pass in binary it cannot index it as string , but blob it should do
nothing, just store it.

I am not trying to sound clever i would actually like someone to explain
why.

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, March 04, 2003 11:18 AM
Subject: Re: [IBO] BLOBs and Interbase 7


> At 10:37 AM 4/03/2003 +0200, you wrote:
> > Try ParamByName['itsName'].AsString
> >does not work.
>
> Hmm. I think you are getting caught up with a missing capability in
> InterBase...
>
>
> > > At 10:12 AM 4/03/2003 +0200, you wrote:
> > > >We have a problem when trying to update a blob in interbase 7
> > > >the error is:
> > > >
> > > >Conversion error from string "BLOB"
> > > >
> > > >The exact same thing works on firebird,
>
> What kind of buffer are you getting Value from? I guess you know that
> Firebird supports assigning a string to a blob, whereas InterBase doesn't?
>
> > > >
> > > >the SQL has one parameter of type blob, we have always set this blob
> > > >parameter using Param.Value :=
>
> The Value method will only work if the object from which you are assigning
> is a variant. A string (e.g. as in Firebird) can be a variant, but a blob
> can't. So, for InterBase, you need to assign a specific compatible type
to
> a Blob: an actual blob, a TStrings descendant or a TStream
> descendant. Use a suitable method for the assignment: LoadFromStream,
> Assign, AssignTo, etc. For blob-to-blob, you can use AsString (even
though
> the objects are not strings, AsString is the streaming method...)
>
> Helen
>
>
> > > >
> > > >i have also tried Param.SetBlobData and Param.AsBlob
> > > >with no success
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>