Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reindexing Routine
Message
De
08/08/2001 17:12:41
 
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:
00541569
Vues:
19
I don't kow, but just want to say that you should put your
DELETE TAG ALL *before* the PACK.

That *might* also get around the problem.
Alternately, you should check to see if HAZARD.cdx exists first (FILE(), and if not, bypass the DELETE TAG ALL.

good luck,

JimN

>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform