Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid .VCT file
Message
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00179421
Message ID:
00179428
Views:
18
>I use myvcx.vcx no problem. Browse it no problem.
>But some Memo fields have garbage.
>I mark the records as deleted.
>When I run the PACK, I got the same message: .VCT file is invalid.
>And now, I do this:
>Use myvcx.vcx
>Copy to newvcx.vcx
>close all
>Set Classlib to newvcx
>And ...... NO PROBLEMS
>
>If you know the way to fix the Memo fields problems, tell to me.

If you had done PACK MEMO after deleting the records, it may have helped. But this may have changed somewhere in VFP versions. The pack command didn't used to clean up memo files unless you also did a PACK MEMO, the last I knew.

A similar problem, if your table has a cdx (which vcxs don't, but this is related to what PACK doesn't do). PACK says it's REINDEXING, but it doesn't actually remove old index entries which now point to records which PACK removed. It just makes sure that all the pointers to existing records are pointing to the correct new record numbers. You have to do a REINDEX command as well as PACK. Again, this may have been fixed in recent VFP versions, but I know it was still true as recently as VFP 3.0.

HTH,
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing
Previous
Reply
Map
View

Click here to load this message in the networking platform