Blob data

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

Article #1515

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

#1515

From: Scott Elgram
Date: Fri, 30 Apr 2004 23:37

23 lines
1466 bytes

Hello,
    I am in need to stream TIF images into a MS SQL database.  I am using
BCB6 and am more familiar with ADO then any of the other DB components
offered.  I know in Delph 7 the code to do this is;

-------------Begin Delphi Code---------------
Blob := TFileStream.Create(ImageFile, fmOpenRead);
  With ADOQuery1 do
      begin
          SQL.Text := 'SELECT * From ImgQueue';
          Open;
          Insert;
          (FieldByName('Image') AS TBlobField).loadfromStream(Blob);
          Post;
          Close;
      end;
--------------End Delphi Code--------------

Can anyone tell me how I can accomplished this in C++?

thanks,
-- 
-Scott Elgram

Technical Details

Message-ID: <4092e332$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ff68206e3ae6c5cb,start
X-Google-Attributes: gid10698b,public
From: "Scott Elgram" <SElgram@verifpoint.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Blob data
Date: Fri, 30 Apr 2004 16:37:23 -0700
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 63.65.31.240
Message-ID: <4092e332$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1083368242 63.65.31.240 (30 Apr 2004 16:37:22 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!news.glorb.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail