Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating foxpro table (idx index) using .NET
Message
 
To
09/10/2014 14:12:18
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01609022
Message ID:
01609076
Views:
43
>For your information, I was in a somewhat similar position myself not so long ago. I took over an old application which used a lot of idx's. Since this caused problems, I had to get rid of all the idx files. I fixed this easily in a few steps:
>
  • The first thing, is to find out which table uses an idx or more, and write down the their name(s) and index key(s).

  • >
  • Add index tags for every table which uses an idx or more

  • >
  • Search for "order" using GoFish, and change these lines if necessary

  • >
  • Search for "Set index to" using GoFish, and change these lines if necessary

  • >
  • Search for "Index on" using GoFish, and change these lines if necessary

  • >
  • Delete all the idx files

  • >

>As always, don't forget to make a backup first, just in case...!
>
>Much to my surprise, it didn't take me more than a few minutes to do the whole conversion, on a very large application. Thanks to GoFish.
>

Sorry for jumping in, but in dealing with old code something to keep in mind is that many people used only 4 characters for the commands, so you need to take into account "orde" and "inde" (I was never a fan of this shortcuts but I did find set inde to and set orde to or even use table orde tag...)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform