But clearly it works in my example. And as long as it works I am not going to complain <g>
>Probably based on this
Re: Parameters (VFPOLEDB) Thread #
1442771 Message #
1442776>and 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.
>>>
"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