🚀 go-pugleaf

"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