General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Update with OpenQuery
Environment versions
SQL Server:
SQL Server 2005
I access from SQL to VFP data. I have created a linked server and i wrote a stored procedure with a command like this
UPDATE OPENQUERY(VFP, 'SELECT Ido, Ccf FROM myTable WHERE Ido=16949') Set Ccf='ABC'
When i execute this stored i see in messages windows of sql server that all commands have been executed but if i requery the data the column ccf has not been modified.
I am very new to sql server, where is my error ?
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only