Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pessimistic Locking/buffering, & APPEND BLANK
Message
De
08/07/1996 13:01:42
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Pessimistic Locking/buffering, & APPEND BLANK
Divers
Thread ID:
00003538
Message ID:
00003538
Vues:
79
Reality check:

If User #1 sets pessimistic record locking on a table and
does an APPEND BLANK, the table header gets locked. This prevents others from doing an APPEND BLANK until User #1
does a TABLEREVERT()/TABLEUPDATE(), which is clearly unacceptable in a multiuser situation.

However, if User #1 sets optimistic record locking on a table and then does an APPEND BLANK followed by an RLOCK(), other users *can* successfully do their own APPEND BLANKS.

So it would it seem that the only real way to implement a
pessimistic row locking strategy using record buffering is
to use *optimistic* buffering in conjunction with explicit
locking via RLOCK().

Is my conclusion correct? This approach on the face of it
seems to be fairly subtle and not something that most developers would be likely to stumble on without a good deal of thrashing around.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform