Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Covnerting flock()/rlock() into SQL Server statements
Message
From
05/06/1999 05:02:11
 
 
To
05/06/1999 01:13:59
Man Wai Chang
Hang Hing Metal Manufacturer
Hung Hom, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00226775
Message ID:
00226797
Views:
24
>How should one translates those flock() and
>rlock() in legacy FoxPro applications?

It's going to depend on how your VFP application buffers its tables, whether you use transactions, and when you expect a record to become unavailable to others for other than read purposes. Acquiring a lock at the start of an edit corresponds closely to a pessimistic lock strategy, while acquiring the lock immediately before revised data is written into the table corresponds to an optimistic strategy.

In some circumstances, the use of RLOCK() and FLOCK() can and should remain in place, especially if you choose not to use table buffering in your application. The commands are still in the language and are still useful in a number of application contexts.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform