SQLRDD running stored procedures

[David H]

Hello,

I have been looking for examples for running existring stored procedures from a MS SQL sever version 11. These stored procedures are passed paramenters from the exec command. Could someone please send me some examples for for doing this?

Here is an example of the type of stored procedures I would like to execute.

ALTER PROCEDURE [dbo].[USP_MIRROR_COMPANY_INSERT]
(
@COID char(3),
@Name char(60),
@CurrLocal char(3)
)
AS
INSERT INTO
pcmfg_Company
(
COID, Name, CurrLocal
)
VALUES
(
@COID, @Name, @CurrLocal
)

Thanks
David

[cul...@gmail.com]

David

simples as

sr_getconnection():exec("USP_MIRROR_COMPANY_INSERT(param1,param2,param3)",,.f.)
sr_getconnection():commit()

Regards
Luiz

[David H]

On Tuesday, May 21, 2013 8:38:02 AM UTC-4, cul...@gmail.com wrote:
> David
>
>
>
> simples as
>
>
>
> sr_getconnection():exec("USP_MIRROR_COMPANY_INSERT(param1,param2,param3)",,.f.)
>
> sr_getconnection():commit()
>
>
>
> Regards
>
> Luiz
>
>
>
> Em terça-feira, 21 de maio de 2013 07h27min41s UTC-3, David H escreveu:
>

Thanks, I appreciate your help Luiz.