ADO & BLOB

Article View: borland.public.cppbuilder.database.ado

Article #572

Back to borland.public.cppbuilder.database.ado Previous Next

#572

From: Gheorghe
Date: Wed, 28 Dec 2005 21:02

21 lines
1582 bytes

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

Technical Details

Message-ID: <43b2fa90@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news4.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,2a73d595005f452e,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Gheorghe" <gmusca@dnt.ro>
From: "Gheorghe" <gmusca@dnt.ro>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO & BLOB
Date: Wed, 28 Dec 2005 23:02:21 +0200
Lines: 24
MIME-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 193.231.117.233
Message-ID: <43b2fa90@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1135803024 193.231.117.233 (28 Dec 2005 12:50:24 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news4.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail