Fabio showed you how to get rid of the deleted records on the client-side.
In the database itself, you will have to open the table as a table, and PACK. You can't do this with views.
Reminder: you don't need to PACK on a regular basis, nor is this appropriate, for performance reasons. Just create a packing procedure that you will run once a month at midnight, or something similar.
>We have a project we're working on that uses Visual Pro Matrix as it will allow us to use local views that can later be turned to remote views for clients that will move up to SQL. Obviously, DELETE FROM in SPT and a DELETE in a view followed by TABLEUPDATE() command removes the record in a SQL table.
>
>However, in VFP a simple DELETE FROM either in SPT or DELETE in a View (and TABLEUPDATE()) only sets the delete flag, it doesn't permamently remove the record. And you can't PACK with a view, nor will SPT work.
>
>QUESTION: How the *%(*$# do you permanently remove records from a local view situation?
>
>Thanks in advance!
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)