Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 2005 ?
Message
From
29/09/2003 14:38:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Error 2005 ?
Miscellaneous
Thread ID:
00833254
Message ID:
00833254
Views:
73
Hello all

I get this error message Error 2005, Index does not match the table, Delete the index file and re-create the index. ? Has anyone got this error before,if so how to handle the delete and recreate index in the multi-user environment.

my reindex routine is
CLOSE TABLES
FOR i = 1 to ADBOBJECTS(laTables, "Table")
  IF !EMPTY(laTables[i])
    IF !USED(laTables[i])
      USE (laTables[i]) IN 0 EXCL
      SELECT (laTables[i])
      WAIT WINDOW "Reindexing : "   + UPPER(ALLTRIM(laTables[i])) + ".DBF" NOWAIT
      PACK
      REINDEX
    ELSE
    	MESSAGEBOX('Other Users on Network may be using the system'+;
    	chr(13)+'Cannot Reindex if others are using the system',16,'Network Conflict')
    	Thisform.release  
    ENDIF
  ENDIF
ENDFOR
CLOSE TABLES
Next
Reply
Map
View

Click here to load this message in the networking platform