>I wanted the primary index to ignore deleted records using SET DELETE ON,but when i delete one and add another with the same primary key,
>the "Duplicate primary key error" appears.
>
>I solved this problem creating a filtered index (FOR NOT DELETE()),
>but Rushmore Technology won't use filtered indexes, so i think
>the application will lose performance when tables have many records.
>Am i right?
>
>Is there any other solution?
>
>I can't execute a PACK statement from the application because the
>multiuser environment won't have exclusive access on the table.
>
>
>Thanks
>
>Juan Carlos
Hi Juan Carlos,
Why don't you recicle deleted records instead of using pack ?
Before appending a blank record use your index to find the first deleted record, then
scatter memvar blank and gather memvar blank, or something like that.
Hope this helps.