Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp bug: rushmore fails with set filter and grid
Message
From
06/05/1998 12:58:19
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
06/05/1998 12:53:21
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00096421
Message ID:
00097418
Views:
47
>Cetin,
>
>This select takes very long time if there are many records returned.
>set filter works much faster since it will not scan whole table.
>Also this does not change base table.
>I want to edit data in large table where records are filtered
>by an arbitrary (rusmore optimizable because there are some indexes) condition.
>I want to edit filtered records in a grid.
>
Well Andrus. OK but is there something new with "set filter" that I don't know. Set filter works much faster than SQL select ? I always thought it was not the case. I should check this again and if true thanks for warning about it.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform