Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reindexing Routine
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Reindexing Routine
Miscellaneous
Thread ID:
00541550
Message ID:
00541550
Views:
46
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.
Next
Reply
Map
View

Click here to load this message in the networking platform