Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a view
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Indexing a view
Miscellaneous
Thread ID:
00098836
Message ID:
00098836
Views:
55
I am using several views in my app and need to set indexes on some. I'm thinking the following is the best approach but would like some input from others:

1. Set views .NoDataOnLoad to .T.
2. Create index for view
3. REQUERY() the view to get data

Is this the best approach and if so where is the best place to put the code for steps 2 and 3. TIA.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Next
Reply
Map
View

Click here to load this message in the networking platform