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