General information
Category:
Coding, syntax & commands
That's what I was trying to say. :)
Thanks,
-Michelle
>Yes, it will replace the key in the index if you delete a record with that key then add a new one with the same key. However, if you have two records with the same key and you delete the one that's in the index it still won't add the other to the index until you REINDEX.
>
>>That's not what I meant. I mean that if you delete the key that's in the index, it is no longer indexed on that key. I'm not sure what it would do if you did UNIQUE FOR !DELETED(). It might replace the key in the index then, but I'm not sure.
>>
>>-Michelle
>>
>>>Michelle,
>>>
>>>That's true. INDEX ON pays no attention to SET DELETED. This can also cause problems with PRIMARY and CANDIDATE indexes. You can deal with this using INDEX...UNIQUE FOR !DELETED().
>>>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only