Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to update dbf from Openrowset?
Message
From
05/01/2009 08:43:26
 
 
To
19/12/2008 15:56:49
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01368838
Message ID:
01370985
Views:
25
>Peter,
>Update command in openrowset() errors but works despite the error. I would however use a CLR procedure if I had to update from within SQL server.
>
>
select * from openrowset('VFPOLEDB', 
> 'c:\myPath\testdata.dbc';'';'',
>  'update customer set contact="Ana TrujilloXX" where cust_id = "ANATR"')
>
>Cetin

Cetin,

I'm sure you would, and so would I if I only knew what you are talking about :-))

I'm behind on Visual Studio - Common Language Runtime (right?) procedure fit's in how and where?
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