Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locking records
Message
 
 
To
06/02/2007 14:35:01
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 7
Miscellaneous
Thread ID:
01192613
Message ID:
01192961
Views:
17
>So if you lock a record in a table that's at or close to the 2GB limit, one of the other records gets a lock placed on it, preventing other instances of VFP from reading that file. This can result in unusual behavior, and, possibly, a Dead Lock scenario.
>
>Please note that this does not affect a "single-user" table, as a process can read through it's own locks.
>
>The formula for finding the amount of potencially affected bytes is roughly:
>
>((Header() + (RecSize() * RecCount() + 1)) - ((2^31) - RecCount()))
>
>Also note that adding a CDX to the table does not cause this bug to go away.

>
>There does seem to be an exposure, but apparantly only when the table is very close to the 2GB limit. Since that's the scenerio we are trying to avoid (the tables will be packed if they get beyond 1.7 GB), it seems to be OK for us.
>
>Thanks again...........Rich
>

You're welcome.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform