Subject Re: [firebird-support] Re: Conversion error from string run time error 2147467259
Author Adriano
An alternative test could be changing blob into long varchar,
but i've tried to do with sql manager without result, is it possible to
convert existing blob field (they has only few char in it actually in
database) into varchar field ?
thanks again
Adriano

2006/7/20, Adam <s3057043@...>:
>
> >
> > I think the problem could be in update blob field, what do you think ?
>
> Could be.
>
>
> > I pass a string and want update a blob field, is it possible ?
>
> Well it definately is possible within iSQL, Firebird does the internal
> casting providing the string is < 32KB.
>
> Perhaps your VB does not like the mismatch of field types. Modify your
> query to not update this blob field and see if it works. If so, you may
> need to use parameters for it.
>
> Adam
>
>
>


[Non-text portions of this message have been removed]