🚀 go-pugleaf

Maybe I should be asking is, "Does the ADO components in CB6 support the new
"Output Stream" property in the Command object that was introduced with MDAC
2.6 and if so how do I access it?

Tim

"Tim Martin" <tmartin@commandalkon.com> wrote in message
news:3d808961$1@newsgroups.borland.com...
> Is there anyone out there who can help in showing me how to return the
BLOB
> that is generated by using the "FOR XML EXPLICIT" within an Stored
> Procedure.  I am using the TADOStoredProcedure object to call the SP and
> return the result.  The Field name is returned okay and even the size
> appears correct but I cannot get the text.  I found a couple of examples
of
> how to retrieve images but I can not get them to work.  Also I used the
> "CreateBlobStream()" method and still was unsuccessful.  When I run the
> query in QueryAnalzer it returns the correct data.  The ADO book suggests
> assigning a stream to the "Output Stream" property of a Command object and
> then accessing the stream.  Does anyone have experience with doing this
and
> can provide a clue to what I am missing?
>
> Current code looks like...
>
> String strTemp;
>
> TStream *pBlob = ADOSP_GetOptions->CreateBlobStream(
> ADOSP_GetOptions->Fields->Fields[0],bmRead);
>
> char *szBuf = malloc( pBlob->Size );
>
> int iSize = pBlob->Read( szBuf,pBlob->Size );
>
> strTemp = AnsiString( szBuf,iSize );
>
> delete pBlob;
> free( szBuf );
>
> Thanks,
>
> Tim
>
>