Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fastest way to seek data in view
Message
From
07/09/2008 09:07:10
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
07/09/2008 06:43:35
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01345528
Message ID:
01345539
Views:
9
>what's the fastest way to seek data in view?
>currently I'm using locate, but I think that's the slowest.
>
>regards,
>
>Jerry

Well, the problem is that a view doesn't have a permanent index. To locate data quickly, you might use a parameterized view. This is often useful in a parent-child situation: the parameter tells the view to only show the children for a specific parent.

Otherwise, explain a little more about what exactly you want to locate.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform