Solved

VISUAL FOX PRO HELP NEEDED!  EASY ONE!!

Posted on 2006-12-01
9
329 Views
Last Modified: 2010-05-18
Ok, our company is in crisis.  We had someone develop some scripts a long time ago in Visual Fox Pro.  The error is really simple I'm sure (I hope) but it's holding up our payroll department!!!

ORIGINAL ERROR:

Error loading file - record number 4.  Form1 <or one of it's members>.  Loading form or the data enviornment : Index does not match the table.  Delete the index file and re-create the index.


That was the original error.  Then I said ok let me try to delete the index file and recreate.  Sounds easy enough.  But I know jack about programming or Visual Fox Pro.   So I poked around and found a EE similar issue where the answer was to delete the CDX files.  

I'm not that stupid that I would delete the files, but I did MOVE the files to another location, then tried to launch it  I got an error.  So I put the CDX files back, but I still get the error.  So now the error is.


TABLE HAS NO INDEX ORDER SET


Please help!!!!!!!!!!!!!

0
Comment
Question by:TheBrothaULuv2H8
  • 5
  • 4
9 Comments
 
LVL 33

Accepted Solution

by:
CarlWarner earned 500 total points
ID: 18056253
It sounds like either the index set (part of the cdx file) is either missing or corrupt.

The initial error you posted probably comes from when the form is being initialized and it is going through the steps of opening up what your programmer had established as tables and appropriate index keys in the DataEnvironment of the form.

I say "probably" because the error message has the loosely worded weasel clause where that is only one of the possibilities.  The other one is that the form (.scx) file has a damaged associated file with it where one of the form's members can't be ascertained.  

But, I would always start with re-creating the index sets for the tables and go from there to troubleshoot problems.

Also, in the future, please post your FoxPro questions in the FoxPro section here at EE.

http://www.experts-exchange.com/Databases/FoxPro/
0
 
LVL 2

Author Comment

by:TheBrothaULuv2H8
ID: 18056264
It appears that you're right on point.  I have after hours of searching found a local guy who's handling it for us.  I'll give you the points because you were correct.  He said the CDX was corrupt.
0
 
LVL 2

Author Comment

by:TheBrothaULuv2H8
ID: 18056266
PS:  If I was smart enought o realize VFP was a database and not a programming language I would have posted it there.  Now I know.  Thanks!
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 18056297
VFP is also a dessert topping. ;)

VFP is an OOP programming language and is a database system and makes a great front-end to any back-end ODBC/OLE DB compliant server engine.

Thanks for the recognition.

[BTW, I hope your help realizes doing a simple REINDEX will at least correct the symptom temporarily and not necessarily fix an index header corruption problem.  We don't knoiw that the index file has that.  But, if it does, it will not go away with a quick and dirty REINDEX command.  The index set must be recreated as a new index set and a brand new file.  Inside baseball stuff, right?]
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 2

Author Comment

by:TheBrothaULuv2H8
ID: 18056312
Thank you for that information!  So far this "consultant" seems to be ok, he claims to have recreated the index set using one of the original files I pulled from an old backup.

Does that sound legit?
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 18056367
It should be OK.  

I was burnt once by using an existing index file that had corruption in the header and it took me more time and unwanted results than I'd like to recall to even discover what the problem was with what looked to be a perfectly legitimate index file.  So, I'm at best sensitive and at worst hypersensitive to index file issues.
0
 
LVL 2

Author Comment

by:TheBrothaULuv2H8
ID: 18056389
Well he hasn't been paid yet I'll run it by him, just to make sure he recreated the file.  That should lead him to believe I'm somewhat knowledgeable on this (when I'm really clueless).  =)
0
 
LVL 2

Author Comment

by:TheBrothaULuv2H8
ID: 18068558
I've confirmed that he recreated the actual files.  Not just a rebuild
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 18070040
That is best.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
allStar challenge 1 52
allswap challenge 6 75
groovy example issue 10 88
Image decoding from Camera 3 72
Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now