Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing a view
Message
 
To
17/03/2000 09:47:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00347008
Message ID:
00347014
Views:
51
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform