Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing on DELETED() - VFP6.0
Message
From
09/10/2002 22:55:42
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00709654
Message ID:
00709664
Views:
15
Hi Sergey,

Thanks, I'd forgotten about NOFILTER.

Regards,
Gavin...

>Hi Gavin,
>
>In case when select is fully Rushmore optimizable foxpro doesn't create cursor but instead opens source table with command similar to USE AGAIN and uses SET FILTER to filter records. Removing index on DELETED() makes select only partialy optimizable. You can add NOFILTER clause to the Select to force foxpro to create a cursor as a temporay file.
Previous
Reply
Map
View

Click here to load this message in the networking platform