🚀 go-pugleaf

try streams.
 TStream *Blob
ADOQuery1->CreateBlobStream(ADOQuery1->FieldByName( "theField"), bmWrite);
    try {
        RichEdit1->Lines->LoadFromStream(Blob);
    }
    __finally {
        delete Blob;
    }

This should do a bit read from "thefield" and dump the results to RichEdit1,
Shouldn't matter if is binary or not

"Arnie Mauer" <xxx@nowhere.net> wrote in message
news:40a8f57a$1@newsgroups.borland.com...
> "kev" <kev@isp.com> wrote in message
news:40a8b874@newsgroups.borland.com...
> > Some time ago I posted some questions regarding Blobs. It turns out that
> the
> > field I was trying to access was defined as VarBinary(8000) so I could
not
> > use blob stram (as indicated by V. Vassiliev in an earlier response).
The
> > advise I was given was to use ADOQuery->Fields->Fields[]->Value  OR
> > ADOQuery->Recordset->Fields->Item[]->Value.
> >
> > Fields->Value yields a NULL or "".  I tried the Recordset, but it does
not
> > seem to be a correct statement.  I finally tried
> >
> > char *Buffer.
> > Buffer =(char*) ADOQuery1->Fields->Fields[4];
> >
> > I get something that looks like it might be a pointer, but can't get any
> > further.  Can someone please assist me in getting this data from this
> field?
> > It is field [4] and is a byte array with the next field [5] defining the
> > length.
> >
> > thanks,
> > kev
> >
>
> I don't know if this will work for you or not.  It works for us, but we're
> reading BLOBs.
>
> AnsiString s = ADOQuery1->FieldByName( "theField" )->AsString;
>
> s.Length() indicates how many bytes were actually read.
>
> HTH,
>
> - Arnie
>
>