>>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
>
>Michele,
>VFPOLEDB doesn't support updating via a linked server. If you use OpenRowSet() instead it gives error but updates.
>
>I wouldn't use VFP with SQL server (it creates other constraints as well). In my honest opinion move completely to SQL server.
>
>Cetin

Thanks, the problem is that i have two applications. Thefirst works in SQL server and the other in VFp. I have to build Stored procedure to update vfp tables, but alternatively i can modify the vfp application to read data from sql server and the update vfp tables. The ideal solution was from sql but i can do it in the other way. It is also intersting to know that oledb provider dosen't permit to make operation to write tables of vfp.