Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexes
Message
From
31/03/2002 20:11:36
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Indexes
Miscellaneous
Thread ID:
00639314
Message ID:
00639314
Views:
39
Hi Guys,

I have a question regarding indexes, I have a remote view that I included in a dbc file. Everytime I want to access that remote view in a form, I place the following command in the load event

Open database dbcname
use remoteviewname in 0 alias aliasname
index on field1 tag indexname

The question is, does the third line creates a permanent index in the base table?

Does this also apply to sqlpassthrough?

Thanks in advance..
Mike
Music Rocks www.musicreserve.blogspot.com
Success is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.
Next
Reply
Map
View

Click here to load this message in the networking platform