Help tutorials etc

[AcornD]

I am new to visual fox pro and have just purcahsed version 8. I have only previously used access to generate all our schools databases but need to link into an sql database now but i am having great difficulty at getting to grips with the program as their are no tutorials or manuals that came with the program and cannot get any till some time in may. any help or tutorials on the program i would be gratefull for.

 

[Mike Gagnon]

AcornD

You may want to start by using the Keyword Search and entering SQL ODBC, I get more then hundred posts on the subject. It might be a start.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[wgcs]

We're glad you found this forum... It's a great place to get answers to your questions!

It's impossible, though, to give a complete tutorial on such a large subject in a limited space; particularly because there are different opinions about how to do what you want to do (VFP is very flexible...)

However, to get you started, these are the main options you have:
1) Use a database container with Remote Views that connect to the SQL database.
2) Use SQL Pass-through: SqlConnect/SqlStringConnect, and SqlExec

These don't have to be mutually exclusive, either...

A hint, too, is that you don't need DSN's on the client machines if you use SqlStringConnect instead of SqlConnect (there's a faq about this, and several topics on the fox wiki).

http://fox.wikis.com

has alot of good discussion in it's topics about interfacing with SqlServer

 

[JRB-Bldr]

Here are some other decent/good references:

On-line Tutorials
Special Edition Using Visual FoxPro 6

http://docs.rinet.ru:8083/GlyadiLisu/index.htm

Mastering Visual FoxPro
A free course of study at Free-Ed.Net

http://www.free-ed.net/fr03/lfc/030101/129/

Microsoft's Visual FoxPro Reference

http://msdn.microsoft.com/library/?url=/library/en-us/fox7help/html/cmoriReference.asp?frame=true

VFP Books
Internet Applications with Visual FoxPro 6.0

http://www.hentzenwerke.com/catalog/intvfp.htm

MegaFox: 1002 Things You Wanted to Know About Extending VFP

http://www.hentzenwerke.com/catalog/megafox.htm

NET for Visual FoxPro Developers

http://www.hentzenwerke.com/catalog/netvfp.htm

WebRAD: Building Web Database Apps with Visual FoxPro & Web Connection

http://www.hentzenwerke.com/catalog/webrad.htm

Client-Server Applications with Visual FoxPro and SQL Server 7.0

http://www.hentzenwerke.com/catalog/csvfp.htm

Microsoft Office Automation with Visual FoxPro

http://www.hentzenwerke.com/catalog/autofox.htm

Good Luck,
JRB-Bldr

 

[Mike Lewis]

AcornD,

Another good place to look for this kind of information is the section of the Help file called "Accessing remote data".

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com