Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on a Remote View
Message
From
01/08/2001 18:31:06
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00538562
Message ID:
00538603
Views:
14
>>Can anyone tell me if you can create an index on a Remote View? If so what is the syntax.
>
>You can use the INDEX ON command to create a temporary index on views. I believe that you'll have to CLOSE INDEXES and recreate the index(es) when you do TABLEREVERTs and REQUERYs.

Fortunately, you don't. Can't hurt, but you don't have to.
The index will automatically reindex on the requery.
Tablerevert seems to act like on any other buffered table in this regard.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform