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 (AT) mfaconsulting (DOT) com wrote:
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 (AT) attglobal (DOT) net
==================