>Hello,
>
>My application is a Client-Server (VFP 6.0)
>I`m using Remote views to insert\update\delete records in free tables (.dbf) through ODBC with microsoft visual foxpro driver.
>
>When I delete a Record in VFP this record is marked for deletion and not eliminated, remote views ignore SET DELETED ON, so when i insert a record with the same index key i have a duplicate message.
>
>How can i avoid this without using command PACK.
>
>Thanks
>Carla
Delete marks the record to be deleted from the view. You need to issue TableUpdate() after deleting the record in the view to actually delete the record from the table.
Hector Correa