Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is INSERT INTO locking???
Message
De
29/01/1999 19:53:55
 
 
À
29/01/1999 19:38:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00182078
Message ID:
00182086
Vues:
13
Hi Ed!

Does this means that I dont have to think about RLOCK()??


Best regards

Per Simmersholm

>>Hi All!
>>
>>Is INSERT INTO only locking the new record if SET MULTILOCK OFF??
>>
>
>INSERT INTO should be locking the table header; someone can have existing records locked, but only. In one person at a time can actually add a record to the table, so, like APPEND BLANK and APPEND FROM, VFP locks the header before it adds new records to the table, and releases the header when it's finished. The new records are not held locked once the table header is released. Once the INSERT INTO completes, the records added are not locked.
>
>>I have 2 terminals accessing the same table. I have some
>>problemes with what is inserted into the table.
>>I have a product number and name (variables) inserted into
>>the table but it seems to me twice a week the number and name is
>>wrong.
>>First I write a label for a pallet, then I store the prod.nr and
>>prod.name.
>>I have 2 terminales operating on the same stock dbf inserting
>>new records.
>>
>>Best regards
>>Per Simmersholm
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform