>OK - I give up.
>
>I have only ever used VFP is XBASE mode.
>
>We got MSDE with VFP7 which is (presumably) functionally equivalent to MSSQLS.
>
>But how do we us it?
>
>Programatically, what do I do to use the server?
>
>What are the commands to create a new database, create a new table, etc. I know how to use Views - and presumably we use remote views to manipulate the database - but what happens when we want to create a new database on the fly?
>
>And where are our tables stored?
>
>David.
>
>PS This is my Christmas project - get across MSDE/SQLS so I can promise client/server applications to my clients IF I can't talk them out of it!
1. Start by creating a connection from VFP to MSDE.
create database MyDBC
CREATE CONNECTION MyConnection ;
CONNSTRING 'DRIVER=sql server;SERVER=(local);UID=sa;PWD=;DATABASE=northwind'
2. Create a remote view to use this connection.
CREATE SQL VIEW MyView REMOTE CONNECTION MyConnection SHARE AS ;
select EmployeeID, LastName, FirstName from employees
3. Use your remote view as a regular VFP cursor.
(your changes won't be saved to the backend, though)
OPEN DATA MyDBC
USE MyView
BROWSE
4. Launch VFP's help and take a look at "Creating Client/Server Solutions" section under "Using Visual FoxPro" to learn more.
Hector Correa