Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00520806
Message ID:
00523419
Views:
18
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