You can not pass named parameters using SPT from VFP. In VFP parameters are defined by position, not by name.
>Thank you.
>
>>The best way is to use SPT parameters.
>>
>>SQLEXEC(, "EXEC mysp ?Param1, ?Param2, ....")
>>* OR
>>SQLEXEC(, "EXEC mysp @Param1=?Param1, Param2=?Param2, ....")
>>
>>
>>>
>>>How do you pass named parameters from VFP to SQL Server using SPT? (If it is possible)
>>>
>>>TIA.
If it's not broken, fix it until it is.
My Blog