Please get comfortable with using the SQL trace monitor. It can deliver a
lot of helpful information when dealing with stuff like this.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Admin" <dkeith@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, March 16, 2001 7:52 PM
Subject: Re: [IBO] Re: Blob insert woes...


> Aage -
>
> Thanks for the reply. I don't know if my post made it clear enough
> (probably not) but the conversion error occurs upon executing an insert
> or append statement, before attempting to assign a value to the fields
> in the new, not yet posted row. I'm fairly baffled by this one. I had a
> routine that worked once before and I never received this conversion
> error, even when I was trying out routines that didn't work.
>
> DK
>
> Aage Johansen wrote:
> > Your problem might be that IB provides no implicit conversion from
string
> > to blob. You will either have to use an UDF (I think a suitable one is
> > provided in the standard UDFLibrary) or let the client (your app)
"assign
> > the string to a blob parameter".
> >
> > Regards,
> > Aage J.