Empty a DBF table

[jimwest1995]

Hello,

I need to remove all the records from my DBF table another word i want to
empty the table and this is what i did

Delete * from MyTable

this work but it does not remove the records from my table it flag them as
delete.

Is there any way i can pack the table, or remove the records

Thank you

[fplesco]

Hello,

I need to remove all the records from my DBF table another word i want to
empty the table and this is what i did

Delete * from MyTable

this work but it does not remove the records from my table it flag them as
delete.

Is there any way i can pack the table, or remove the records

Thank you

Hi jimwest1995 -

I had also encountered that problem before. I did some research and some inquiry but I found no answer.

What I did, as a workaround is after I issue the DELETE command, I called a FOXPRO program that issues "pack" command to the DBF table.

If you can't get answer from this, maybe you can try this workaround.

[Killer42]

I just searched Google for "VB PACK DBF" and found around 125,000 entries. It might take me a while to check out all of them :) so here are the first few.

http://support.microsoft.com/kb/119116

http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/pack-a-foxpro-dbf-v50-table-from-visual-basic-621477?cv=expanded#

http://www.dbforums.com/archive/index.php/t-319152.html

http://www.dotnet4all.com/dotnet-code/2004/10/how-to-pack-foxpro-tables-with-vbnet.html