>>Probably prototyping it in ADO would work and you would check with >NextResultSet. Also you might try:
>>{? = call storedProc(?,?,?)}
>
>Could you clarify this, please? How would call to this function look syntaxically?
>CREATE PROCEDURE usp_test
> @Number INT,
> @NewNumber INT OUTPUT
>AS
>SET @NewNumber = @Number + 3
>RETURN @NewNumber
>GO
>
>I just don't know where I'm supposed to put quotation and question marks, brackets, where variable names go etc.
>
>Thanks
First ? is the return value. ? in parentheses represents procedure parameters:
"{? = call usp_test(?,?)}"
I wonder why you want the return value with such a procedure. You already have it as an output parameter.
Cetin