>Hate this "marked for deletion" crap. I come from an SQL environment that when you deleted a record, it was gone. If you wanted to mark records for deleteion, you added a delete flag column to your table. We never allow our clients to see deleted records, and they never have the opportunity to undelete. Yet they have to run a pack and reindex periodically.
>
>Is there a way to truly (madly, deeply) delete records from a table?
>
>Brenda
See the PACK command. This will get rid of records marked for deletion.
Also, as Ed said, SET DELETED ON will make it so users don't see deleted records.
Also, if you have to run PACK in SQL periodically, that probably means the records weren't gone for good either. If you couldn't get them back (ie. RECALL), well, I would call that a weakness, not a strength.
Joe
Joseph C. Kempel
Systems Analyst/Programmer
JNC