Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File Locking
Message
 
 
To
12/09/1997 09:32:00
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00049804
Message ID:
00049840
Views:
61
>Is it true that VFP locks files to be updated automatically when
>then Buffering status is setted to "4"(Ver 3.0 in Win 3.11)?
>Do I need to manually issue a FLOCK command to lock the file?
>Pls advise. Also please advise on what need to be taken care
>when developing VFP in a Novell network environment?
>(It's my first time developing in network...)Thanks a lot.
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com

I prefer row locking, and use file locking only when absolutely necessary. Row locks are easier to get in a multi-user environment. No record can be locked in order to get a file lock. Since VFP came out, I almost always use optimistic row buffering (SET EXLUSIVE OFF, SET MULTILOCKS ON). With some exceptions, I let VFP handle all the locking for me.

There are other threads here that I have participated on that describe pros/cons of how to add new records - SQL-Insert, append blank, append from, etc. The latest thread on this was no longer than 1 to 2 weeks ago.

There are also some Knowledge Base articles (red dice) -- FAQs, Win32 -- on getting user names, system data/time, etc from Novell systems.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform