>>>Yes, you can: filter your primary key index on NOT DELETED(), and deleted records won't bother you. However, this has a drawback; since filtered indices won't be used by Rushmore, you will need to add a
regular index on the same expression, so your queries can be optimised.
>>>
>>Uhhh! Are you sure about this? My experience is that a deleted record still will not permit a new record with the same primary key to be added to the table irrespective of SET DELETED status.
>>
>>regards,
>
>
>SET DELETED and INDEX ON FOR DELETED() are two different issues. You are correct that SET DELETED will still prohibit the reuse of a primary key. INDEX ON FOR DELETED() will not.
Hi, Craig
I tried that a while back. It seems to work ok in the development environment, but had problems in the run time. Or maybe I was doing something else wrong. Who knows?
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.