🚀 go-pugleaf

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