Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting VFP Front end to SQL Server
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00500444
Message ID:
00500578
Views:
14
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform