At 03:06 PM 13/01/2005 +1100, you wrote:

>thansk Helen - but you might be mssing the RVF Vs RTF stuff -
>I'm createing a stream from one blob field , then converting it to RTF, then
>assigning this new stream to the other field..
>Where do I set the OTHER blobfield to write?

Oh, right, sorry, I thought you were writing back to the same column but I
see it's a different one and there's more to this than meets the cursory
eye (the eye is a bit more cursory than usual today due to smoke!!)

But it's impossible to tell from your code sample where things are coming
from and going to.

You begin by setting up a stream called stRVF that has no appearance of
having been declared. You make a call to create this stream but then do
nothing with it.

Then you call a couple of methods, referring to two other streams, again
with no indication that they were ever created.

Then you use the Assign method of TIB_ColumnBlob to assign one of these
(externally created?) streams and you get an AV.

Some hints:
Be sure that you create and destroy the "intermediate" streams explicitly
in try/finally loops.

Test whether the statement is actually prepared before you begin to rely on
reading from and writing to it.

If it's prepared, test the one you are reading from for NULL and drop
through to the "finally" block to destroy the streams.

Otherwise....more info about how you arrive at the sample code.

Helen