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:
00242255
Views:
26
>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...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform