>I'm going to be using VFP with SQL
>
>How do I get started? Is there a SQL interface? How do I access
>data from within VFP?
>
>I know these are general questions, but I'm not sure where to start
>
>TIA
Get this book (
http://www.hentzenwerke.com/catalogavailability/csvfp.htm) from Hentzenwerke on C/S development using VFP and SQL Server. It should help a lot.
As for the general questions:
1. Is there a SQL interface? Enterprise Manager gives you the ability to configurae SQL Server as well as create and maintain databases, tables, views and indexes. Query Analyzer gives you an interface to generate and test SQL statements.
2. There are a number of ways to access the data in VFP. You can use Remote Views (see help topics on this) or SQL Pass-thru (SQLCONNECT, SQLDISCONNECT, SQLEXEC, etc.). Check out the help on these as well.
Good luck! You're in for some fun!
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao