Well, maybe not you exactly - please forgive me, if I misquoted you.
You basically said it works despite the error, but to use CLR procedures.
Like I said, I'm not familiar with CLR procs and would prefer to do it in a plain sp with T-SQL.
And Sergey wrote
"It may not be possible because VFP OLE DB provider supports only read (query data) access when used in a linked server/OPENROWSET"
I guess that's were "stubborn" comes into the picture :-))
>>I've posted something similar in the VFP section and capacities like Sergey & Cetin figure it can't be done, so it's most likely not doable.
>>
>>But I, being a stubborn SOB, don't give up that easy, which is why I'm pestering you good people with this same issue :-)
>>
>>Consider MyDbf, MyKeyField, MyNeedsToBeUpdatedField (no DBC, btw) and MyServerTable, MyServerKeyField, MyServerValue
>>
>>How would you go about this?
>>
>>TIA & BR
>>
>>Peter
>
>Peter,
>What is the question? And what was it I said that it was impossible?.
>Cetin
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)