Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing with filter
Message
 
 
To
13/05/2008 11:39:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01316662
Message ID:
01316673
Views:
19
This message has been marked as a message which has helped to the initial question of the thread.
>>The good solution would probably be not using filters at all. What exactly you're trying to achieve?
>
>The child table that has the filter is bound to a grid. The request is that the grid have the ability to sort on the columns. This table is/was the child table. But if I change the child index the parent-child relation is broken. So I used a filter. This is a legacy app and I have know idea of what will be affected if I start changing up the way the data is presented.
>So I was just wondering if there was a good way to sort the filtered table.
>
>Thanks,
>Dan

Don't use Filters with Grids. You may use Local Views instead with indexes. You would achieve much better performance using Local View idea.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform