Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set filter
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00520806
Message ID:
00523419
Views:
16
I think so too, theorically. OTOH, there are some work-intensive grids, that are based on chunks of data from big tables, where the requery takes a long time, and this can be sometimes inacceptable.


>Jaime,
>
>SET KEY is a workaround and FP2.x style code IMHO.
>
>Parameterized views are a much better solution.
>
>>I agree with you if you try to exclusively set filter to a big table, but not if you use set key beforehand. I have an application where a grid browses a table ( 300k records ) directly. I first use set key for the first subset to be shown ( that's where set filter shows very slow performance ), but then i activate any filter condition i want, and it's very fast!
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform