The only way I know of to do this in VFP is via ADO - and the command object. The first parameter is always RETURN_VALUE. I tried to get this to work in SPT - but no dice. It may be possible somethere in the ODBC API - but it is not exposed in VFP.

Return values are not that useful since they can only be numerics (I believe). An output parameter OTOH - is not limited in its data type.


>
I'm aware about output parameters but original question was how in VFP retrieve return value of a stored procedure ( the one in RETURN 123) not how to return value from the stored procedure. I thougth that you new some trick to do that with output parameter but it turned out that you where answering wrong question.
>