Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using the Filter Expression when designing table indexes
Message
From
07/10/1998 15:04:23
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00144726
Message ID:
00144729
Views:
19
Hi Michel ----

>
>In the good old FoxPro for DOS days I was used to always
>creating an index on DELETED() in order not to display
>deleted records.
>
>I now want to use instead the FILTER field available in the Table
>Designer to have in there the !DELETED() clause in order to
>achieve the same thing. Does anyone know if there are
>performance penalties associated with using filter clauses
>in index definitions ?
>

Why do you want to do this? Just create an index tag on DELETED() and forget filters. To quote a certain South Park character, "Filters are bad, OK?" (Sorry -- I know you may not get the reference).
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform