Subject Re: [IBO] Blob insert woes...
Author Jason Wharton
TBlobStream is for BDE based blob handling only. Use the
TDataset.CreateBlobStream( ) method instead.

Also, I recommend that you not use TIBOQuery for batch inserts. Use the
TIB_DSQL component instead. You can assign the contents of a BLOB in an
input parameter and do it that way. See the BlobInserts sample application.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Admin" <dkeith@...>
To: <>
Sent: Thursday, March 15, 2001 7:11 PM
Subject: [IBO] Blob insert woes...

> I wrote a routine that takes a graphic(bmp,ico,jpg,jpeg,gif) and inserts
> it into an IB6 Dialect 3 blob column. This worked fine for a while, but
> I must have done something to break it.
> Now I can't get it to work anymore. I've tried so many ways to make this
> code work that I can't begin to remember them all. So I'll include some
> code from one of my latest attempts to give you an idea. I get the error
> message 335544334 'conversion error from string' every time I attempt to
> do an insert or append. I've had various erros during my attemts to fix
> this problem - this is only the latest