Marc,
FYI, a linked server with VFP OLE DB provider supports only read access to VFP data. If you still want to use unsupported feature, try
'delete from avantage_root...rcvbil where rcomcli="20_007994" and rcompte<>"031384"'
>I try do delete a row in a Foxpro table via SQL Server linked server, It works, but I receive an error message.
>
>Here is my delete instruction and the error message
>
>select * from openquery(avantage_root,'delete from ava01/rcvbil where rcomcli="20_007994" and rcompte<>"031384"')
>
>------------------------------------------------------------------------
>Serveur : Msg 7357, Niveau 16, État 2, Ligne 1
>Could not process object 'delete from ava01/rcvbil where rcomcli="20_007994" and rcompte<>"031384"'. The OLE DB provider 'VFPOLEDB' indicates that the object has no columns.
>OLE DB error trace [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='VFPOLEDB', Query=delete from ava01/rcvbil where rcomcli="20_007994" and rcompte<>"031384"'].
>
>
>
>In spite of this error, the records are well deleted from Foxpro DBF table.
--sb--