>>BTW, if I am running a VFP UI and using views to get the data from a server, does that server have to run SQL (SQL-server, Oracle, DB2, My SQL, etc.) or could it be a VFP database?
>
>It can be anything that you have an ODBC driver for.
>
>The difference is that a database server (SQL-Server, Oracle) processes the requests (SQL statements) on the server and sends back the results, while with a VFP database, the requests are processed on the client. This doesn't mean that the entire database/tables are sent back to the client, but, usually, at least the indexes must be loaded on the client. So, different optimization problems, etc.
>
>Vlad
Vlad, I'm not sure if I asking this the right way. I'm clear that the way I have written my programs up to now that the data requests and updates are performed on the client. The Novell Netware server just acts like a hard disk to the client computer.
But assume that I rewrite my app (not too hard with VFE) to use remote views into a database server running on an NT machine somewhere else on the network. That machine can run an SQL database. Can it run a VFP database?
I'm imagining two different VFP programs. One on the client acting as a UI; the other on a server machine fullfilling SQL requests.
Why would I want to do this? No per unit pricing for one reason.
Peter
Peter Robinson ** Rodes Design ** Virginia