Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a view
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00098836
Message ID:
00098845
Views:
26
>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, actually you can do it whereever it is convenient for you, in many cases I use Cursor1.Init() for this, where Cursor1 is your view cursor in DataEnvironment.

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform