Hi all,

I am having difficulties when deleting records permantenly
from my table from within a running application. I have tried
to SET DELETED ON, but that doesn't work. I have also tried
the PACK command, but unfortunately the table must be SET
EXCLUSIVE ON, and I need it to SET EXCLUSIVE OFF, therefore
I can't really use the PACK command.

You see, I have two composite fields as my one PUBLIC KEY, so if I delete
a record, I want it to be reusable straight away in case a user wants to add
a new record, but this cannot be accomplished if the deleted record
is not permanenly removed from the table in question.

Is there another way to permanently delete/remove records from a table?

All suggestions welcomed.

Thanks in advance,
Mick