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
--sb--