Empty DBF table

[jimwest1995]

Hello,

I need to Empty a DBF tabel, i used the following

delete from test.dbf

the problem is it is not deleting all records, it is not deleting any record it flag them to star

How can i empty the all tabel

Thank you

 

[s-c]

If you are connected correctly, try:

delete from test

 

[mwightman]

DBF File

What type of a provider are you using to access the dbf file. The * is a marker for a deleted row and you should not see them when you do select. Normaly there is a utility for compact the files and remove the deleted records