>>I've been building apps using the form wizards, building filtered indexes, using seek/ locate, creating combo boxes wich represent fields in some table, giving the user the oportunity of skip from one record to the next, prior, and so on.
>>
>>How are these features affected if I migrate to a Sql server database?. I've been told that no filtered indexes are posible, and that I must start by thinking on sets of records, use of views, stored procedures......
>>
>>How does an app work when built to use sqlServer or Oracle databases?
>>
>>Tks
>
>Client server takes a whole different philosophy when building your apps. ONe of the key goals in Client Server architecture is keeping recordset sizes to a minimum by forcing the user to specify some criteria before showing a list to choose from.
>
>In VFP, we implement Client Server with Remote views. To use a remote view, you must set up a connection to an ODBC datasource, and then you can add tables to your view from that datasource.
>After your views are created, they can be treated just like local views in your forms. REQUERY them, TABLEUDATE them, etc. But the transition from local to remote data is easyt only if you have planned ahead of time by making all of your forms access data through views. Rather than pulling in a whole table and issuing a SET FILTER, set a parameter for your view and REQUERY. Rather than SET ORDER and SEEK, you need to bring the records in in the right order with the view definition and if you move the record pointer with LOCATE. You can still use indexes with views, but these indexes have to be created on the fly at runtime, because the contents of a view are dynamic.
>
>Finally, the form wizard is a good learning tool, but that is really all. You won't get very far before you realize that your needs go beyond what is provided by wizards. The sooner you can ween (sp?) yourself off of VFP's wizard's the better off you'll be in the long run.

Thanks for your response. This makes me want to get more. Is there any demo app wich I can use to see the real thing? or any documentation about building 3-tier apps with vfp? (not just theory, but directions in HOW to make every step!!)