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.