>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.

Just do the PACK once a month at midnight, when nobody is using the tables.

>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.

Filtering the index on NOT DELETED() will solve the uniqueness violation.

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

Yes, you can re-use deleted records. But that is too much trouble, IMNSHO.