Thanks Myron. I forgot about the problems of indexing a view with table buffering.
>In some cases you may need a couple of other steps:
> 1.5 - Make sure buffering is row buffering
> 2.5 - Restore table buffering if applicable.
>
>-myron kirby-
>================================
>>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.comNever mistake having a career with having a life.