>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