Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Packing & Reindexing
Message
 
To
24/11/1996 12:06:52
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00013305
Message ID:
00013324
Views:
31
>>>The Help files for PACK state that the command rebuilds all open index files. Is it safe to assume that .CDX files, open by definition, are re-indexed?
>>
>>John
>>
>>Yes, if associated with the packed Table then they are re-indexed. Memo files are also packed (they can get wild). Please not though the VFP indexes are not the same indexes your Mom & Dad used to use! VFP Tables now have backlinks in the header to the DBC, Primary index info is stored in the DBC, etc. To truly completely reindex you need a third party tool or do a lot of 'head banging'. It took me at least a week to write a routine. Learned a lot...
>
>if you are going to write such a thing
>look into the gendbc which can come handy for this

Arnon

Yes GenDBC is a corner stone of any true reindexing scheme. So is a Meta-Index file to store the info on the Indexes.

To be quite honest Stonefields Data package (forget the real name) may be best since could be a time consuminf and somewhat 'dangerous' process.

This is such an involved process that even ProMatrix contacted me on how I do it. After you learn it & do it it is not so bad but the process of doing it is not much fun.... At least it not almost a year ago when less was known about VFP.

HTH
Tom
Tom
--------------------------------
Tom O'Hare
407-299-4268 -- tom@redtile.com -- http://www.redtile.com/
Independent Programmer Using Visual FoxPro, Visual Basic & more...
Operations Manager -- Virtual FoxPro User Group (VFUG)
http://www.vfug.org/ -- tom@vfug.org
President -- Central Florida FoxPro User Group (CFFUG)
http://www.redtile.com/foxpro/
Universal Thread Most Valued Professional (MVP)
http://www.transformation.com/foxpro/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform