Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating foxpro table (idx index) using .NET
Message
De
09/10/2014 15:30:05
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01609022
Message ID:
01609078
Vues:
45
>>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...)

I know, and I should have included the shorter version. Actually, the first thing I did with that application, was to replace all the shortened words with the full ones. That was actually a far easier job than I expected, mostly because it was an all prg project.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform