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:
00242261
Views:
21
After all the replies I've switched it over to locate and it works fine. The view only contains 3 records so...

There must have been an abundance of solar flares yesterday afternoon, nothing I tried worked :)

Thanks for all the help.


>>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...
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform