Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update dbf data with data from SQL server
Message
From
19/01/2009 07:06:21
 
 
To
19/01/2009 06:33:37
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01374980
Message ID:
01374996
Views:
13
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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform