Hi Jim,
No there is no DELETED() tag and based on the number of index tags with this FOR clause I'm starting to assume the DELETED() tag is what the developer meant to do. The duplicate key info is possible. I'll have to check the code for how adds are started and aborted. Thanx for the info.
>Hi Colin,
>
>Do these table also have a TAG on "pure" DELETED()???
>
>Do these filtered TAGs correspond to the table's PRIMARY key field?
>
>If they do, then possibly they exist for the sole purpose of preventing a "duplicate key" error while adding records to the table.
>
>Just some thoughts
>
>Jim N
>
>>>Hi Colin,
>>>
>>>>I've inherited an app that for most of its tables has index tags with a FOR !DELETED() filter expression. Is this beneficial or no?
>>>
>>>
>>>Depends on how you use them. For Rushmore these indexes are non-existant. IOW, only SEEK is able to make use of this index, and of course SKIP or SCAN WHILE constructs.
>>>
>>>Christof
>>
>>Do you mean that Rushmore doesn't use the index at all or that it just ignores the filter expression?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.