Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
...index does not match the table. Delete the index ...
Message
From
15/01/2004 05:36:08
 
 
To
14/01/2004 12:15:10
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00866376
Message ID:
00867031
Views:
26
Thanks, Dragan

Yeah I've used genDBC for this purpose in the past. My reservation is that the last time I generated a program to build my database for a client, in VFP7, the result didn't work (It had worked fine for me in the past in VFP3).

Anyhow, the problem has been resolved now (see up in thread). Thanks again for your input.

Terry

>Check the code generated by Gendbc - you have the code for setting the relations there. And to remove relations before indexing (so your dbc would still be valid while you're manipulating indexes), you can edit a copy of those lines to DROP FOREIGN KEY before you do your indexing. Tried, works.
>
>The only trouble is when the indexes or FPTs are so thoroughly screwed that you can't even open the table; in such a case, only a serious tool like SDT, or some serious hacking can help.
>
>Sometimes, a table with a fpt-gone-south can be saved by copying the data to a temp table, zapping, and appending from the temp. Doesn't work each time, probably covers only the case when the error is on an unused block.
- 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