>It's my strong opinion that SET DELETED should be ON by default in an application. Any deleted record should be considered as none-existent. If application requires to keep deleted records around for whatever reason than such record should have special field to mark it as deleted instead of VFP DELETE. It will be consitent with any other database you can/will use.
>
Sergey,

Do you know any other database engine that uses Deleted flag? I don't.