>>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

Thanks Nick. Sounds like the best location to me.