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

Try the TAGCOUNT() function. It should return 0 if there are no indexes.

---
Jonathan Chan
Previous
Reply
Map
View

Click here to load this message in the networking platform