In the help file of vfp 6 - sure you have to dig a bit, there is quite a lenghty discussion about the differences between using remote views vs - SPT technology. and why you might find yourself using both - depending on how much data you want, and various other factors.

There have been many debates here on what is better. and why one programmer chooses one method over the other. The only thing I can tell you. is that you should really understand how they all work, before you start writing too much code either way. but for what its worth. I have started working with sql passthrough and not bothering with the wrapper to it called remote views. To me its a bit harder to code that way. as everthing I need towrite needs then to be perfect sql statments to my server but in the long run I get better performance, and and I can walk through every step and know whats going on. and it is true, that it seems eaiser to use remote views, and actually I use them sometimes for ad hoc reporting, or if I need a quick snapshot of some data for a special extract, but for application level connection, its always spt.

Just my thoughts. (p.s) I use a Mysql server, and an hp 3000 as my backend servers. so my opinions do reflect that fact that I dont have the cleanest migration path from the server to client. and that may be affecting my thoughts.

Bob Lee




>You can start by visiting Fox Wikis at http://fox.wikis.com/wc.dll?Wiki~CategoryClient/Server
>
>>We may be looking at converting a VFP app to utilize SQL-Server as the back-end database, using HostWindows to serve the whole thing up.
>>
>>I've recently re-read a FoxTalk article by Jim Falino (Turn your VFP app to Client Server), which talks about the basic fundamental approaches to keep in mind:
>>
>>-View-based data entry forms
>>-Funneling all the data access commands into as few functions/methods as possible
>>-Stored procedures
>>-Limiting result sets as much as possible (reporting/viewing a slice of data)
>>-Unbound controls
>>
>>Can anyone else suggest other approaches/advice, along with any reading material? (Only book I have that covers both SQL Server and VFP is Client-Server Applications w/h Visual FoxPro and SQL Server, by Chuck Urwiler.)
>>
>>Also, if anyone has stories to share about HostWindows...
>>
>>TIA,
>>Kevin