How can I retrieve from, say FoxPro, the value returned by a stored procedure? Under SQL Server 7.0, the command was simply:

lnResult = oCommand.Parameters('RETURN_VALUE').Value

In SQL 2000, RETURN_VALUE is no longer recognized.

Thank you,