Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is INSERT INTO locking???
Message
From
29/01/1999 19:53:55
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00182078
Message ID:
00182086
Views:
15
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform