Its not a question of marking them as IN or OUT or INOUT....

CREATE PROCEDURE `sp_test01`(IN _var1 INT, IN _var2 INT, OUT _Ret INT)
BEGIN

START TRANSACTION;

-- Do some insert

COMMIT;

SET _Ret = 1;

END$$

....its that in C#

I have to call this with variables called _var1,_var2 and _Ret.....if
you get that wrong it doesn't work. Specifically WRT getting the _Ret
variable!

Anyway, thanks for the reply.

D.

daniel@mfaconsulting.com wrote:
> Its not a question of marking them as IN or OUT or INOUT....
>
> CREATE PROCEDURE `sp_test01`(IN _var1 INT, IN _var2 INT, OUT _Ret INT)
> BEGIN
>
> START TRANSACTION;
>
> -- Do some insert
>
> COMMIT;
>
> SET _Ret = 1;
>
> END$$
>
> ...its that in C#
>
> I have to call this with variables called _var1,_var2 and _Ret.....if
> you get that wrong it doesn't work. Specifically WRT getting the _Ret
> variable!
>
> Anyway, thanks for the reply.
>
> D.
>

Yep, that's true. That's the way SP's work.

But the same is true with C# functions, is it not? If you don't call
them with the correct parameters it doesn't work?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================