Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement