Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PACK without Exclusive setting
Message
From
24/03/2008 10:28:40
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
24/03/2008 09:27:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01304852
Message ID:
01304887
Views:
11
>Is there any way I can use PACK command without setting EXCLUSIVE ON?

No theory (*).

When you pack, everything in a table is made afresh - table itself is copied to a new file (only not deleted records, that is), all the index tags are created from scratch, then the old table (and its cdx and fpt) are deleted and the new table is renamed to old, and then reopened. If anyone else had it open, it would have to be closed (with buffers flushed or reverted - but cleaned up anywhere) right underneath them, and reopened when done (and with large tables on slower machines it can take time). Should the buffers should be written down or reverted? No matter what answer we choose (write, revert, leave dirty or ask each user what to do and hope they'll answer soon), we'd be getting in trouble. Which is why packing is done when alone.

----
for lurkers out there, "there's no theory" is short for "there's not even a theoretical chance", and I actually hope I'm not too much out of phase with the current slang at home, i.e. that the expression is not hopelessly out of fashion

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform