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!