Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexes on Remote Views
Message
 
To
02/04/2007 15:27:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01211442
Message ID:
01211477
Views:
15
Some techniques I use often.

This comes from the VisualMaxFrame Framework

Open the remote view without data

=CURSORSETPROP('BUFFERING', 3, 'vr_RemoteView')

INDEX ON field1 TAG field1

INDEX ON field2 TAG field2


REQUERY()


It's faster to index without the data.

As I recall you have to have buffermode set to 3 to index a view.

After you've greated the indexes you can set buffermode to 5
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform