Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append Blank vs. Insert - SQL
Message
De
14/01/2000 14:24:01
 
 
À
14/01/2000 13:21:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00318136
Message ID:
00318271
Vues:
30
>Deadly embrace? This is when two processes are waiting for one another two finish before continuing- how could you do this with VFP?
>
>SET REPROCESS TO AUTOMATIC has always done it for me- I have never had a problem. I use both INSERT INTO and APPEND BLANK depending on the situation, and have not been bitten with either one.

I think the kind of scenario he's thinking of here is two users running the same application. User 1 locks record X, User 2 locks record Y, then User 1 tries to lock record Y while User 2 tries to lock record X creating a circular locking dilemma. I don't know if this is his exact situation since he seems to be dealing with INSERTs, but I assume this is what he is referring.

BTW, I know you are familiar with this situation, but responded for those who may not have heard of a "deadly embrace."
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform