Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt CDX suddenly
Message
From
03/11/2004 12:13:56
 
 
To
03/11/2004 11:50:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 3
OS:
Windows '98
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00957602
Message ID:
00957707
Views:
15
Copy that, Gary. I haven't read that book. All the same, HAVE you bloody well tried reindexing?!!! :-))
Even as a first resort? Who knows what weird and wonderful things go on behind the scenes in FP commands like PACK. Sergey does :-)

Cheers

Terry

>>>Well that's news to me. I thought Pack just permanently removes rec's >>marked as deleted. If that's the case, and you haven't reindexed, then you >>WILL get the same indexing problem everyday. 'sup to you
>
>My understanding is that pack does the following
>
>COPY TO WITH PRODUCTION FOR !DELETED()
>DELETE FILE
>RENAME TO
>
>Therefore it is mightier that the REINDEX!
>
>The Hackers Guide to VFP7 states:
>
>"PACK permanently removes all marked records. What it actually does is copy all the unmarked records into a new file and then rename the new file. (The table is also reindexed.) Because PACK does this behind the scenes, there is a small chance for data loss if your system crashes during a PACK."
>
>Regards
>
>Gary.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Reply
Map
View

Click here to load this message in the networking platform