>PMFJI
>How do you capture it in a sql-passthrough call? I've tried doing =SqlExec(nHandle, "exec sp_getstring ?inputparm, ?outputparm") but I always get an empty value on outputparm.
In order to call a stored procedure that returns values through output parameters with VFP's SPT, you have to use the ODBC calling syntax. It would look like this:
LOCAL outputparm
outputparm = 0
SQLExec(hConn, [{CALL storedprocedure (1, ?@outputparm)}])
This information is discussed in the VFP help. Chapter 21: Implementing a Client/Server Application. The section is called Using SQL Server Input/Output Parameters.
I haven't figured out any way to capture the return value from a stored procedure. If I need it, I return it through an output parameter.
-Mike