🚀 go-pugleaf

I'm trying to retrieve a block of binary data (~5k bytes) from a SQL
Server database table. The column name is 'data'.

Using TADOQuery, I want to read the record, and write the data from the
result set into memory. Also, I need to do the reverse (write the 
record). This should not be rocket science.

Here's what I have so far after a day and a half experimenting with
snippets from old newsgroup posts:


<snip>
typedef struct{
	...
}CONFIG_DATA;
CONFIG_DATA *cp;
TADOQuery *iQuery;
TBlobStream *bptr;


iQuery->Active = false;
iQuery->SQL->Clear();
// just get one record:
iQuery->SQL->Add("select data from config_data where ID = 3001");
iQuery->Active = true;

// got a runtime error before I put this line in:
iQuery->Edit();


bptr = 				 
dynamic_cast<TBlobStream*>(iQuery->CreateBlobStream(iQuery->FieldByName("data"),bmRead));

if(bptr) bptr = ReadBuffer(cp,bptr->Size);
// home free if you get here!

<end snip>

Works fine until I get to CreateBlobStream(), which returns a null 
pointer.  I've tried tons of methods to create the TBlobStream pointer,
none of which work, many of which won't even compile (taken straight 
from BCB5 help).

This should not be difficult, but I'm having no luck.  I have been using 
ADO database objects with BCB5 for years, just never had large binary 
fields.

Any kind soul who is willing to either give me the few lines of code I 
need, or point me to a SPECIFIC WORKING example anywhere cyberspace, I 
will happily add you to my Christmas card list (it's too late for a 
valentine).

TIA

Mike