Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter, Form and Variables
Message
From
01/09/2008 18:27:37
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01343935
Message ID:
01343947
Views:
19
>Jay,
>
>The way I handle this situation is that I long ago I stopped using filters at all. I use SELECT to get the records I want in the cursor and order them the way I want them ordered. No filters, no variables to go out of scope, no THISFORM to get barked at by the SET FILTER condition, and only the records I want in the cursor. With Rushmore it is nearly as fast as a filter, even filters can get slow when using a grid to display the data.

I was thinking of that, but then I ran into the problem in how to easily update the base table with any changes made to the cursor. Using the base table itself for the grid seemed the easiest way, but maybe not.

UPDATE: Could I scan through the cursor and use the UPDATE command to update the base table? Have not done something like that before.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform