The book Client-Server Applications with Visual FoxPro and SQL Server 7.0 should be of help to you. http://www.hentzenwerke.com/catalogpricelists/csvfp.htm

>I am about to embark on a project using VFP as front-end and SQL-server as backend. I know very little about using SQL-server, so I will be developing using local views of dbfs extracted from SQL-server tables, and will switch-over to remote views when the application goes live.
>
>My question is as follows. There are many fields in the SQL tables with names having more than 10 characters. How can I extract my local tables so that the field names are not truncated? I guess they will have to be part of a database container, but I'm not sure where to go from here. For example, would I have to create a separate .dbc containing the .dbf definitions as a remote view, in which case how would I get the data into a .dbf (which has to be in a .dbc itself)?
>
>Any help would be appreciated.
>
>Alan