Probably based on this
Re: Parameters (VFPOLEDB) Thread #
1442771 Message #
1442776and this article
http://www.west-wind.com/WebLog/posts/660586.aspx>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.
>>
If it's not broken, fix it until it is.
My Blog