>>>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
>>
>>If you want the record gone, but can't take the hit of grabbing the file with an exclusive lock, just blank the record, then delete it and set deleted on. Be aware that set deleted doesn't impact sql queries unless you add the where not deleted() into the select statement.
>>
>>After you blank the records and since they are marked for deletion you can pack the table later.
>
>Sorry, SET DELETED ON affects SELECT_SQL queries, and correspondingly WHERE NOT DELETED() should not be used there.
Well, I just tested it to be sure and set deleted and you are right. If you don't have set deleted on it will pull the records marked for deletion.
Sorry, my bad!< G >
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright