Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexes on Remote Views
Message
From
27/05/1998 16:41:07
 
 
To
27/05/1998 16:33:49
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00102526
Message ID:
00102529
Views:
30
>I have an application I built using DBF files in the DBC. I now need to create the database in Sybase. How do I make use of the indexes from the Sybase database through remote views? Do I need to create my own indexes on the remote views?
>
>I tried a sample form using a remote view on a particular table. I referenced the Sybase table's index in the Order property in the data environment for the view and received an error.
>
>Thanks in advance.
>
>Scott

You can get remote view ordered using order option of View designer, however there is no way to use backend indexes on front-end side. You can index remote view recordset as any other table using INDEX ON ... TAG ... (cursor should be in row buffering mode, buffering=3)
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform