Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on a Remote View
Message
From
01/08/2001 18:14:40
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00538562
Message ID:
00538593
Views:
11
>Can anyone tell me if you can create an index on a Remote View? If so what is the syntax.

Only after the view has been USEd. It won't persist, so you'd have to recreate it when you need it. If it's table buffered, it will have to be switched to row buffering first, then indexed, then switched back.

When the remote view is closed, the index is erased (it's a temp file)

That said, the syntax is the same. e.g.
Use myremoteview
Index On myfield Tag myfield
HTH
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