Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting Started With SQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00489563
Message ID:
00489573
Vues:
12
>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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform