Could you post the code of your stored proc....???
>Hi John,
>
>Can the output from a SP be captured in VFP? I made a few tries but I can't make it work:
>
>
x = 20
>SQLEXEC(nConn, "EXEC p_procname ?x OUTPUT")
>
>x is still 20 after the call to SQLExec... Something I'm missing? If working within SQL Server (Query Analyser), it's working fine.
>
>Thanks!
>
>
>>
>>CREATE PROCEDURE customers_add @Name Varchar(50),@newkey INTEGER OUTPUT
>>