Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reindexing Routine
Message
From
08/08/2001 17:12:41
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00541550
Message ID:
00541569
Views:
25
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform