I used the second Sergey's example and change the order of parameters. And the data in SQL was filled according to the parameter names not position. I will test again to be sure that this is how it works.

Update: I tested again and it looks like parameters can be passed by name. Why did you assume that they cannot?

>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.