Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ReBuilding or Fixing Indexes - How?
Message
 
To
18/08/1999 23:01:17
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00255117
Message ID:
00255193
Views:
15
>I got an error message when I tried to run a form during development. It said I needed to delete the CDX and recreate it for the file. Deleting, no problem, I can handle that... recreating, problem how?
>
>There were 5 indexes for various fields in the file. I ended up having to run VALIDATE DATABASES RECOVER (as prompted) and then had to manual put the indexes BACK in the database in the PROJECT. There has to be a better way.

In addition to what Nigel said, I keep separate little index PRGs, each one containing the indexing code for each primary table. 5 is no big deal, but when you get up to 20 or so tags, these PRGs are extremely handy.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform