How to insert IMAGE into MS SQL 7 via TAdoStoredProc?

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

Article #6008

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

#6008

From: Max B Shahab
Date: Fri, 17 Nov 2000 18:47

24 lines
1561 bytes

I work with MS SQL 7 and C ++ Builder 5.

How can I insert IMAGE into MS SQL 7 via TAdoStoredProc? This is a SQL
stored proc below:

CREATE PROCEDURE sp_AddPhoto (@idphoto INTEGER, @photo IMAGE)
AS
BEGIN
  SET NOCOUNT ON
  DECLARE @ptrval binary(16)
  EXEC sp_dboption 'photo', 'select into/bulkcopy', 'true'
  SELECT @ptrval = TEXTPTR(photo) FROM photo WHERE idphoto = @idphoto
  WRITETEXT photo.photo @ptrval @photo
  EXEC sp_dboption 'photo', 'select into/bulkcopy', 'false'
  SET NOCOUNT OFF
END

What (and how ;-) must I write in Builder?

myDataModule->spAddPhoto->Parameters->ParamByName("@photo")->Value = ???

It will be fun if You'll show me a codesample.

Much thanks.

Technical Details

Message-ID: <3a157d15_2@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!xfer13.netnews.com!netnews.com!newspeer1.nac.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!195.239.167.13

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,52a92f5cf2d383c0,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2000-11-17 10:50:37 PST
From: "Max B Shahab" <maxim@cic.volgadmin.ru>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to insert IMAGE into MS SQL 7 via TAdoStoredProc?
Date: Fri, 17 Nov 2000 21:47:06 +0300
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 195.239.167.13
Message-ID: <3a157d15_2@dnews>
X-Trace: 17 Nov 2000 10:46:45 -0800, 195.239.167.13
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!xfer13.netnews.com!netnews.com!newspeer1.nac.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!195.239.167.13