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

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Gregory Sorokoletov Mon, 22 Jan 2001 18:11

#5815

Author: 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

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

#5822

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads