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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
