Re: Calling an ServiceProgram with a returnvalue

I could of course, wrap such a function inside another

storedprocedure, and add the

returnvalue as an extra parameter, but i was wandering if somebody knew

howto do this.

That's how you do it. There is no facility to return a value from a proc
call except via an output parameter.

Technically I guess you could also return the value as a scalar (single
row single column result set) and do an ExecuteScalar() on it, but
that's downright silly, especially considering the code the provider
goes through to handle that. ExecuteScalar does the entire proc call
including processing output parms and then goes on to open a cursor on
the result set and process the first row/column. Not the end of the
world, but silly since you're doing the output parm processing anyway.

-Walden