>>>I have a primary index (ordernum) on a table (orders).
>>>
>>>If I delete record ordernum=1 then try to add a new
>>>ordernum=1 I get a message stating that the uniqueness
>>>of primary key ordernum is violated. Is there any way
>>>to make the vfp5 ignore deleted records when adding a
>>>new one with the same key?
>>
>>
>>You would have to add the NOT DELETED() filter to you primary key
>>
>>
>>
>>- Brian
>
>Yes... I see that would work but is that a good practice?
You have to determine that for yourself.
Usually it isn't because filtered indexes are not usable by Rushmore. All queries that would normally use the index, like inter-table joins, would not be optimizable anymore.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao