Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update dbf data with data from SQL server
Message
De
19/01/2009 07:06:21
 
 
À
19/01/2009 06:33:37
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01374980
Message ID:
01374996
Vues:
8
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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform