Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is INSERT INTO locking???
Message
From
29/01/1999 20:07:46
 
 
To
29/01/1999 19:53:55
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00182078
Message ID:
00182090
Views:
12
>Hi Ed!
>
>Does this means that I dont have to think about RLOCK()??
>

RLOCK() wouldn't be applicable to INSERT INTO; the alternatives are to use FLOCK() to acquire a lock on the whole table (the record doesn't exist, so there's no record to RLOCK()), use the file exclusively, or rely on the automatic locking of the header from INSERT INTO. If you need to lock the record you've just added after the INSERT, you needto issue an 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
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform