General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problema updating from SQL server
Environment versions
Network:
Windows 2003 Server
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 use Visual Foxpro OLEDB provider versione 9 Sp2.
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