🚀 go-pugleaf

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
> =======================================
>
>
>