I know nothing about VFP or how it's setup. It looks like some computers have 3.2 others have VFP6. We started getting Error 114 Index does not match the table. I was told to find the cdx file associated with it and delete it, but all the cdx files don't have any specific names in front of them ex. ADV0001.cdx or TYL0001.cdx. I don't know what any of this means, so I created a backup folder and started taking out the cdx files and deleting them from the server and putting them back if nothing changed. Well something changed and made it worse. Now we can't create new customer files or view old ones. Error 12 Variable 'this changes depending on the option chosen' is not found.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Error 12: Variable ' ' is not found
- Thread starter keen01
- Start date
By 'blindly' deleting the CDX files you have introduced an inconsistency for the data tables which need them.
Typically a CDX file has the same base filename as the data table to which it applies.
Example: ADV0001.CDX belongs to ADV0001.DBF
And an attempt to open (or USE) ADV0001.DBF after the associated CDX file has been deleted will most likely result in an Error.
The errors you list are different and likely caused by different things.
1. Index does not match the table
One or more of your table indicies appears to have become corrupted for some reason.
2. Variable ' ' is not found
Some part of your code is looking for a variable which is not properly defined. Typically this is a memory variable not a data table field. Based on your other problems this might be a missing variable which is part of a data table index expression.
Hopefully you have source code and Visual Foxpro to start debugging these issues.
I'd HIGHLY recommend using VFP and the code to debug the problems rather than using a Sledge Hammer and deleting data table files (or files associated with data tables).
Also using VFP would allow you to re-build any problematic data table indicies.
Good Luck,
JRB-Bldr
Typically a CDX file has the same base filename as the data table to which it applies.
Example: ADV0001.CDX belongs to ADV0001.DBF
And an attempt to open (or USE) ADV0001.DBF after the associated CDX file has been deleted will most likely result in an Error.
The errors you list are different and likely caused by different things.
1. Index does not match the table
One or more of your table indicies appears to have become corrupted for some reason.
2. Variable ' ' is not found
Some part of your code is looking for a variable which is not properly defined. Typically this is a memory variable not a data table field. Based on your other problems this might be a missing variable which is part of a data table index expression.
Hopefully you have source code and Visual Foxpro to start debugging these issues.
I'd HIGHLY recommend using VFP and the code to debug the problems rather than using a Sledge Hammer and deleting data table files (or files associated with data tables).
Also using VFP would allow you to re-build any problematic data table indicies.
Good Luck,
JRB-Bldr
Mike Lewis
Programmer
Keen01,
This is bad advice.
What you need to do is to re-create the indexes. However, if you don't know how to do that or what the implications are, you could end up doing more harm than good.
Given the circumstances you described, this is one of those cases where you really need to call in a knowledgeable person to do the job for you. Here in the forum, we can give you theoretical advice, but given your lack of experience with FoxPro, it would be very difficult to talk you through the steps needed to diagnose and solve the problem.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro tips, advice, training, consultancy
Custom software for your business
This is bad advice.
What you need to do is to re-create the indexes. However, if you don't know how to do that or what the implications are, you could end up doing more harm than good.
Given the circumstances you described, this is one of those cases where you really need to call in a knowledgeable person to do the job for you. Here in the forum, we can give you theoretical advice, but given your lack of experience with FoxPro, it would be very difficult to talk you through the steps needed to diagnose and solve the problem.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro tips, advice, training, consultancy
Custom software for your business
- Status
Similar threads
- Locked
- Question