Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index problems, but not real.
Message
From
18/03/2006 08:03:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Index problems, but not real.
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01105532
Message ID:
01105532
Views:
58
Hello,

When a batch process is updating a VFP table, we often receive error messages like "Index does not match the table" or "Index is corrupted, pleased rebuild it", but when we check the table or index, there is no real problem.
Of course, the error makes another process abort.

How to wait for the table to be updated correctly and stop receiving those messagges? Concurrency is the problem here.

Some Try/Catch blocks inside a "Do While" help, but what is the best method to Retry an operation: Every second? N Times?

Thanks,
Juan C.
Next
Reply
Map
View

Click here to load this message in the networking platform