>Is there a resource (book, website ...) that explains how to design an interface when using client/server.
>
>I'm considering to migrate for some applications from local VFP database to a database server. But there are some situations I'm wondering how they 're generally solved (I know THE solution doesn't exist ...)
>I have written an own framework that allows quickly create forms, that work the way I want, but it relies strongly on VFP local database indexes (for display ordering and SEEKing). I'm wondering how this is generally solved as these indexes aren't available in client/Server (not for that kind of operations anyway ...).
>
>Lots'a questions, much possible solutions BUT I don't want to invent the hot water NOR make wrong choices ...


There are several ways to get at your data in C/S applications.
- ADO record sets
- SQL Passthrough
- Remote views

While not necessarily the best choice of the three, remote views are probably the easiest to implement. You must use SQL commands exclusively for all data access/updates/adds/deletes. You can index the cursor/view once you get it.