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.