Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Corrupt CDX suddenly
Versions des environnements
Network:
Windows 2000 Server
I have an application on site with approx 25 users. Application is in VFP3, neither data nor application has changed for sometime.
However in last couple of weeks keep getting problems with records that are not correctly in the index. What I mean by that is browse natural order all records fine, set order to IndexA record in not in order, key runs something line 101,102,105,103 etc. Set order to IndexB and record is fine.
I do a simple copy to, delete, append from and record takes it's rightfull place in index.
Any ideas what might cause this all of a sudden?
Gary.
PS. We have done a full pack on all tables but problem is still occuring.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement