Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you seek() on a view?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00241999
Message ID:
00242256
Views:
22
>>The others have shown you how to index a view so you can use SEEK. This is a good method, and I use it all the time. But if all you need to do is to move the record pointer in a view that contains only a few records, it would be easier (and probably faster) to just use LOCATE FOR
>
>That's a good perspective, you really should try to avoid using views large enough to require a SEEK :)
>
>I use the view indexes merely for setting grid header-click sort order...

Me too. That's the only reason, really, and to be able to an incremental search text box in grids based on a view.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform