i am using...rs.open "delete from abc.dbf where empcode='" & sdfkjdkf &
"'",cn,3,1

this statement is deleting the record from the foxpro table, but it is not
parmanently deleting from the table..

Dipak

I think you need to run your SQL on the connection object that the recordset
is bound to, not the recordset object itself. Let me know if your working
with a "free" .dbf table, or a table bound to a database container, a .dbc
file, and I'll follow-up with an appropriate example. Are you using ODBC or
the VFPOLEDB provider shipped with VFP7?

One more thing to consider is that when records are deleted from a .dbf
table, they are simply "marked" for deletion, meaning they are still in the
table until you do a  "pack". Consider this a *temporary* delete, as these
records can still be recovered. Similar to dropping folders/files in the
recycle bin. However, once the table is packed, all records marked for
deletion are *permanently* deleted and cannot be recovered.

HTH