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