>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
Do you have to COMMIT the data?
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!