Rather than a remote view - use pass through - select your "scope" into a local VFP cursor and index on that. Remote views are resource hogs and for tasks other than maintenance should be avoided (a bit too firm?:-)
>Hi All,
>
>I've got remote view on a Linux Server working... a little surprized at first I didn't think it would work and I'd be forced to exploring Samba or something like but it works just fine.
>
>Is there a way to take advantage of mySQL primary and regular keys through the remote view ? What I mean is can we set some option so we can use a seek from the Visual Foxpro side against a view or are we limited to generating single record returnsets ?
>
>
>thanks,
>
>Don
Imagination is more important than knowledge