rhondabrabbin
Technical User
- Nov 11, 2002
- 87
This is the error I am getting in the company database. The file itself says: "Source is out of date"
Can anyone help me to fix this?
Can anyone help me to fix this?
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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Index does not match datbase file. Recreate index. vers.2.6
- Thread starter rhondabrabbin
- Start date
- Status
How about re-indexing ALL of your data tables?
Do you have a utility that will run through all of your data tables and re-create the INDEX?
If not within the application itself, can you create one through the FP Command Window?
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
Do you have a utility that will run through all of your data tables and re-create the INDEX?
If not within the application itself, can you create one through the FP Command Window?
Good Luck,
JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com
- Thread starter
- #3
rhondabrabbin
Technical User
- Nov 11, 2002
- 87
I have tried to reindex all the files but it gets to one of them and that is where I get the error. I am not an expert at foxpro so please use simple terms.
And thank you so much for taking the time to help.
Rhonda
And thank you so much for taking the time to help.
Rhonda
bobmpalmer
Programmer
This was a querk in 2.6 and prior if the index was a compound CDX.
If you know the index tags then you can do the following at the command prompt to clear the file header. First delete the company CDX file
SET EXCLUSIVE ON
SET SAFETY OFF
ON ERROR
SELE 0
USE COMPANY.DBF
USE COMPANY.DBF
By issuing the USE twice FoxPro will open the table with the index entry cleared
You can then reindex
E.G.
INDEX ON <field> TAG <indexalias> OF Company.dbf
You could also use the utility prog FoxFix to repair the index available at
Bob Palmer
The most common solution is H2O!
If you know the index tags then you can do the following at the command prompt to clear the file header. First delete the company CDX file
SET EXCLUSIVE ON
SET SAFETY OFF
ON ERROR
SELE 0
USE COMPANY.DBF
USE COMPANY.DBF
By issuing the USE twice FoxPro will open the table with the index entry cleared
You can then reindex
E.G.
INDEX ON <field> TAG <indexalias> OF Company.dbf
You could also use the utility prog FoxFix to repair the index available at
Bob Palmer
The most common solution is H2O!
- Status
