>Hi
>
>lnReturnCode = SQLExec(lnConnectionID, 'exec Candidate_Insert_Blank ?1000000001', '@lnCandidateID')
>
>The 10000000001 parameter is the new record ID for the stored procedure insert, the lnCandidateID is the local VFP variable I want to fill with the return value from my stored procedure.
>
>Regards
I understand, but as I said, this is not the correct way to invoke procedure with multiple parameters (where one of them is OUTPUT).
If it's not broken, fix it until it is.
My Blog