Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append Blank vs. Insert - SQL
Message
De
14/01/2000 13:21:39
 
 
À
14/01/2000 09:53:40
Dave Emerson
Dc Emerson Consult8Ng, Inc
Destin, Floride, États-Unis
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:
00318230
Vues:
36
>I am trying to avoid the "deadly embrace" syndrome with a shared network table. The documentation states that both APPEND BLANK and INSERT - SQL lock the table header and recommends using APPEND BLANK to avoid conflict, but I have thought that INSERT was the better method, however yesterday we had that dreaded conflict.
>

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.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform