General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Joe,
As you have been told, a filtered primary index (or any filtered index for that matter) will *not* be used by Rushmore.
BUT. . . there is nothing stopping you from having a second index exactly like your primary index but *without* the filter. Once you do so Rushmore is FULLY OPERATIONAL once again.
Cheers,
jimN
>>>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?
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