Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding candidate key conflicts in a VFP DBC
Message
From
19/01/2005 02:56:44
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00978227
Message ID:
00978429
Views:
27
This message has been marked as a message which has helped to the initial question of the thread.
>>What about to change this Index. Just add a Filter for .NOT. DELETED() in it.
>
>Well, I though about that, but as it would ruin Rushmore optimization, I'm trying to avoid filters.
>
>Thanks!

Martin,

Add another regular index then for Rushmore to use since it will avoid using the !deleted() index
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform