You might start here.
http://www.hentzenwerke.com/catalogavailability/csvfp.htm

I hear its a wonderful book, (I might be buying it next week when I go to devcon) but its worth a look.


One of the reasons you find yourself confused, is that there are three ways, not one, but three different ways you can use VFP to communicate with a MS SQL server, I wont go into detailes here.
But when you are reading about SPT, it means sql pass through. meaning that you send the actual sql statment to the server, and get the results back. a little harder to code that way, but you do know exactally what is going on in each step.

Then there are these things called 'Remote views' or RV's Badly named in my opinion but they are a buffer between you and your data, internally it buils the sql staments, and handles the connection - disconnection for you, the actual sql staments are held in your local DBC' and hidden a bit, so you dont have to mess with it. the same data is accessable, but you get at it using the gui, dragging and dropping fields in the view manager, etc.

Then there is ado record sets, ole-db. Not touching them yet, I cant say what they do or how they work. just be aware at this point, that the instructions assume that you know what they are talking about before they explain it. you are not alone in the learning curve for sql - vfp. It takes a little time getting use to the gargon, / lingo, but its basics are solid, and after working with the issues for about a year, I think its worth the extra effort getting to know how it all works.

Bob Lee






>Hallo all
>I’m right in the beginning of learning how to use an MS SQL server together with VFP6. I have been reading the MS VFP6 Programmers Guide for a while now, and it is not so easy to follow the discussions in the book, and I have more questions now, then I had before I started. I can’t take your time and write down all my detail-questions here, I must learn more about VFP-SQL first. But there is one question I can ask:
>Can anyone give me some web addresses where I can find good easy information’s about how to do this?
>And another thing. I’m just to begin with VFP7, and the manuals from MS are not good. Does anyone have a tip on a good book about VFP7 that I can buy? There are so many, and I don’t know which to choose.
>Thank you in advance
> /Kjell