🚀 go-pugleaf

Try using TADOBlobStream to read the data from the field...

Mark

"Gheorghe" <gmusca@dnt.ro> wrote in message
news:43ba6b7e@newsgroups.borland.com...
> I forgot to mention that the 1 byte that I get when reading the BLOB
(Memo)
> is 0x3F ('?').
> The same happens when trying to manually Copy and Paste the content of the
> Memo field directly from Access.
> Isn't this some Windows way of signaling the impossibility to interprete
the
> content?
>
> Any help/hint would be appreciated,
> Thanks
>
>
>
> "Gheorghe" <gmusca@dnt.ro> wrote in message
> news:43b2fa90@newsgroups.borland.com...
> > Hi,
> >
> > I'm trying to read a Memo field in a MS Access DB, using BCB6 and
> ADOQuery.
> > I constantly get the size of the blob as 1 byte, no matter what
technique
> I
> > use.
> > Any ideas?
> >
> > Here's the code
> > =====================================
> > aCon->ConnectionString = "Provider=MSDASQL.1;DSN=MS Access
> > Database;DBQ=dbPath;DefaultDir=dbdir;DriverId=25;FIL=MS
> > Access;MaxBufferSize=2048;PageTimeout=5;PWD=password";
> > aCon->Open();
> >
> > aQuery->SQL->Clear();
> > aQuery->SQL->Add("SELECT BLOBFIELD FROM TABLE;");
> > aQuery->Open();
> >
> > TBlobField * bfield = (TBlobField *) aQuery->FieldByName("BLOBFIELD");
> > int len = bfield->Size;        // This is always 1
> > =======================================
> >
> >
> >
>