>Is it in anyway possible to add (or simply create) indexes in a local view (created from a table that as multiple indexes)?
>
>I can't seem to find it in any book and, after hours of searching, have not encountered any clues that it is possible although, I think, it seems like a perfectly normal and simple thing to do.
>
>Thanks in advance, Stephane.
Stephane, you can index a view just as any other table in VFP. The only restriction is that you cannot index a view in Table Buffereing mode, but there is an easy workaround - switch to Row Buffering using CURSORSETPROP() and then back to table buffering. You can even keep your index, if you index to .IDX file SET INDEX and REINDEX after you REQUERY() your view.
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