Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
F/S to C/S Help
Message
From
12/12/2016 16:33:10
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01644874
Message ID:
01644945
Views:
47
> I just wish there was a clear outline of how to re-write the app for C/S. I am still a little unclear about things but i guess I'll have to jump in soon and learn as I go.

The most basic 3 things:

1. Don't fetch any more data than you will use. (It is not like just opening a table in FoxPro and positioning on top of the record you want to update)
2. Make sure your database tables have one field that is a unique key so SQL Server can find the record(s) you want to update.
(Technically, you could use some multi-field key, but it gets painful pretty fast.)
3. Record locking is a no-no.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform