Re: Passing variable of type "TABLE" from C++ Builder to SQL Server stored procedure parameter

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

Article #5822

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

#5822

From: Ronald van Dam
Date: Thu, 25 Jan 2001 13:26

26 lines
1571 bytes

Hi,

Just simply use ParamByName to set parameters en use ExecProc to execute the
stored procedure

Gregory Sorokoletov wrote:

> Hi gurus!
>
> How can I pass value from C++ Builder to SQL Server stored procedure,
>
> if type of parameter (in stored procedure) is 'TABLE'?
>
> For example, I have some sp:
>
> CREATE PROCEDURE test_table_parameter
> @p1 TABLE
> AS
> ...
> RETURN(0)
>
> Please help me to write C++ programm, to execute this stored procedure?????
>
> Best regards,
>
>  Gregory

Technical Details

Message-ID: <3A70298F.676F0046@frg.eur.nl>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!193.190.198.17!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!130.115.136.242

References: <3a6c762d_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,1cffb29627f20d2
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-01-25 05:40:07 PST
Message-ID: <3A70298F.676F0046@frg.eur.nl>
Date: Thu, 25 Jan 2001 14:26:39 +0100
From: Ronald van Dam <r.vandam@frg.eur.nl>
X-Mailer: Mozilla 4.75 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
To: Gregory Sorokoletov <gregory@metrosvyaz.ru>
Subject: Re: Passing variable of type "TABLE" from C++ Builder to SQL Server 
 stored procedure parameter
References: <3a6c762d_2@dnews>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 130.115.136.242
X-Trace: 25 Jan 2001 05:26:53 -0800, 130.115.136.242
Lines: 27
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!sn-xit-03!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!193.190.198.17!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!130.115.136.242

Reply to Parent Message