Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reindexing Routine
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00541550
Message ID:
00541577
Vues:
14
>I am building a Reindexing routine with the following code structure:
>
> USE HAZARD IN 0 EXCL
> SELECT HAZARD
> PACK
> DELETE TAG ALL
> INDEX ON HAZ_CODE+STR(CAR_NO) TAG HAZARD OF HAZARD
> INDEX ON DELETED() TAG DELETED OF HAZARD
>
>This works fine except when the .CDX does not exist in which case the error is 1707=Structural CDX File is not found.
>
>Suggestions to circumvent that would be appreciated.

You might want to try the routine I wrote to create a data dictionary of sorts on your data and reindexing based on that. IMHO it is easier than keeping up with a large prg.

www.waynemyers.com --> Links&Code --> Code Examples
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform