I have the big book of Pinnacle reports that includes Roberts report, very helpful also.

Question for you, since you teach this stuff now. I just came back from the So. Cal. Developers Conference. Many of the folks I talked to that were there last year, said that at that time ADO was the buzzword of the day (This time XML was). Now that ADO has settled in a bit, most people seemed to indicate that ADO was best used when dealing with data over the internet. I attended a session on VFP & SQL Server where ADO wasn't even discussed, just mentioned as available.

Is this your belief also, or are you discovering different?

PF

>You should also read Robert Green’s book "Visual FoxPro Client Server Development" published by Pinnacle/Whil Hentzen. It was published in 1996 as a special report series and may or may not be available. You might try calling Pinnacle Publishing at 800.788.1900 (as listed in the book).
>
>The book was focused on VFP3 and SQL Server 4.2. It works with VFP6 and SQLS 6.5 and 7.0 without modification.
>
>The sample code works with the SQL Server sample database "PUBS". Although the framework is incomplete (and he states so) it will get you well on you way to understanding the issues of remote data and large-scale databases. Remember even at their largest possible size VFP's native databases are tiny.
>
>Any book that is focused on VB does not take into consideration the most powerful aspects of VFP remote data capabilities, SQL Pass through (not remote views as some people think).
>
>Now that SQLS 7.0 is OLE DB and OLE Server enabled you should also consider learning ADO/RDO and OLE Automation.
>
>As you can see, VFP and large scale databases is a favorite subject of mine. I teach several courses on the subject.