Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
HELP!! Do FOR clauses use table locks?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00042738
Message ID:
00043456
Vues:
35
> We are experiencing network related error messages as more and more > users > use our app. The error messages are: "Attempting To Lock..." and > "Record > Not Available, Please Wait..." What's happening here is that one user has the record/table locked, and a second user is trying to establish a lock as well. This may be because of a FOR clause, but it is more likely because of pessimistic buffering or an explicit RLOCK() or FLOCK(). Have a look at the SET REPROCESS command. Here's the first part of the .HLP file from 5.0a: Syntax SET REPROCESS TO nAttempts [SECONDS] | TO AUTOMATIC Arguments TO nAttempts [SECONDS] Specifies the number of times Visual FoxPro attempts to lock a record or file after an initial unsuccessful attempt. The default value is 0, the maximum value is 32,000.
Paul Russell
EMail: prussell@fox.nstn.ca
Phone: (902) 499-5043
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform