>I'm new to views and I would like to find out the following :
>
>I have a database called euc.dbc and I need to find out
>When to use Remote views v/s Local views on my VFP database.
If you want your app to be scalable to high-end databases, use Remote Views with the assumption that you manipulate data using ANSI SQL.
>The .exe and the database(euc.dbc) is going to be located on a server.Users from remote locations will be accessing this application.
>Some forms will be using tables from this euc.dbc and I was thinking that the application would be faster if I use views instead of tables.
Using traditional approach of manipulating data in VFP is still faster than using VIEWS. But, if you are thinking of scalability and C/S approach, then use views.
View is just one of the several mechanisms available to manipulate data whether VFP data or from any server based databases. Look also into SQL Pass Through, ADO, Store Procedures, etc.
Local Views is directly connecting to VFP database table without using ODBC. Use ODBC, then your View becomes Remote.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."