Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Append Blank vs. Insert - SQL
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.
What are the recommended procedures for multiple users adding records to the same shared table, i.e., SET REPROCESS, and APPEND BLANK vs. INSERT - SQL? In some cases a procedure may add numerous records over a short period.
BTW I am using private datasessions in my forms and the application is in VFP 5.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement