I'm trying to run a stored procedure on SQL Server and get back a return value and the value of a parameter that has been changed. The problem with this is that I can see how to do this in Transact SQL, but I'm not doing too well in VFP6.

Can anyone tell me how to do this and/or point me to a good reference on how to do these things?

TIA,