1. Use (yourDBF exclusive
2. pack

But what is the point of deleting the records, why don't you simply re-use them? I don't want to offend you, but I learnt many, many years ago that you should only delete records permanently very rarely, for instance every tenth year...!

>We use Coldfusion with a vfp datasource and run a query that deletes all records in a vfp table:
>delete * from vfptable
>
>However, as would be expected, it marks all records for deletion, rather than physically deleting them.
>
>How would we pack the table as part of the query? Would it be a stored procedure? If so what might that look like and where would it be placed?
>
>Thanks in advance.