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.
>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only