calling SQL sp from Axapta

[gb]

Well, actually the question was how to catch a returned value from stored procedure. Say, my return procedure returns an integer:
RETURN @return_value

I don't want to loop through the result set, I just want to get that returned value.

The other question, I usually use ODBCConnection, Statement, and ResultSet to accomplish what you showed in your examples.
Is there an advantage to use one approach vs. another?

Thanks for your input.
Good day.