Re: Image in blob

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

Article #681

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

#681

From: GIGI
Date: Mon, 27 Feb 2006 07:49

14 lines
1666 bytes

It depends on the OLE ODBC driver You're using. But in most cases u can
use LoadFrom(File/Stream) method.
TAdoQuery aq;
//init here  the AdoQuery
aqInsert->Parameters->ParamByName("PIC")->DataType = ftBlob;
TMemoryStream pPic;
      if ( FileExists( sPicPath ) )     {
        pPic->LoadFromFile ( sPicPath );
      }
      aqInsert->Parameters->ParamByName("PIC")->LoadFromStream( pPic,
ftBlob );

Hope this helps.
GIGI

Technical Details

Message-ID: <1141026583.362963.243810@t39g2000cwt.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!t39g2000cwt.googlegroups.com!not-for-mail

References: <43fdda76$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,a60165f06754909
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!t39g2000cwt.googlegroups.com!not-for-mail
From: "GIGI" <GIGIak@gmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Image in blob
Date: 26 Feb 2006 23:49:43 -0800
Organization: http://groups.google.com
Lines: 15
Message-ID: <1141026583.362963.243810@t39g2000cwt.googlegroups.com>
References: <43fdda76$1@newsgroups.borland.com>
NNTP-Posting-Host: 193.178.240.4
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1141026588 2286 127.0.0.1 (27 Feb 2006 07:49:48 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 27 Feb 2006 07:49:48 +0000 (UTC)
In-Reply-To: <43fdda76$1@newsgroups.borland.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1,gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 proxy.wasko.pl:8080 (squid/2.5.STABLE9)
Complaints-To: groups-abuse@google.com
Injection-Info: t39g2000cwt.googlegroups.com; posting-host=193.178.240.4;
   posting-account=PFrdfw0AAAA_QidtkZvP6KEg-q3dvcRn

Reply to Parent Message