Hello we have a Visual Foxpro application we wrote in house years ago for managing inventory and customers, work tickets. It serves us well, but we have not done any maintenance for at least 5 years.
There are about 6 main table ranging in size up to 15MB.
I have noticed at least once where a report brings up no data for a specific part, however have verified that the part does show on the work ticket.
So my thoughts are that we probably need to re index and pack.
I have been trying to find someone to come in and do this but the one programmer I found could find his way around but was not real familiar with Foxpro. I kept saying I wanted to reindex the tables but he said Foxpro would do this automatically. Later I read about Pack and Index commands.
I think this is a simple process, basically running some commands on the tables and then copy them back to the server directory. Correct me if I am wrong.
So I have come to the experts!
Looking for some simple direction on what I need to do to do this.
Should I index? What is the process?
Should I pack? What is the process?
Anything else I need to do for maintenance?
Anything I need to be cautious of other than the usual make backup first etc?
Is there a program I can buy that would take care of this for me? I have seen various programs for fixing tables etc. but I am not sure if they would be of any benefit.
I am ussuming that once I have run the pack and index process once I will be comfortable with it.
Any experts on Foxpro in Vancouver BC?