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

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

Article #5815

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

#5815

From: Gregory Sorokoletov
Date: Mon, 22 Jan 2001 18:11

25 lines
1352 bytes

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: <3a6c762d_2@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!bignews.mediaways.net!fr.usenet-edu.net!usenet-edu.net!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!194.85.159.49

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,1cffb29627f20d2,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-01-22 10:10:23 PST
Reply-To: "Gregory Sorokoletov" <gregory@metrosvyaz.ru>
From: "Gregory Sorokoletov" <gregory@metrosvyaz.ru>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Passing variable of type "TABLE" from C++ Builder to SQL Server stored procedure parameter
Date: Mon, 22 Jan 2001 21:11:17 +0300
Lines: 28
Organization: Metrosvyaz
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 194.85.159.49
Message-ID: <3a6c762d_2@dnews>
X-Trace: 22 Jan 2001 10:04:29 -0800, 194.85.159.49
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!bignews.mediaways.net!fr.usenet-edu.net!usenet-edu.net!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!194.85.159.49