Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index file is in use; .cdx
Message
De
31/07/2006 15:14:16
 
 
À
31/07/2006 15:00:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01141821
Message ID:
01141902
Vues:
15
Hi Steve,

Seems strange that it is (only?) the .CDX that is causing the trouble here.
Do you have code that is specify and 'index' and is inadvertently referring to the cdx? I'm thinking of commands like USE with the INDEX and/or ORDER clause.

Another **GUESS** is that some SELECT is creating a "filtered result set" instead of a real cursor. I've had cases where explicitly closing the cursor-name didn't close it when it was a filtered result set.
Assuming your version supports it, try adding NOFILTER to your single-table select statements to see if that makes a difference.

Good luck



>I can't pack the table since I can't gain access to it?
>
>Foxpro will not open the table unless I reboot my fileserver. I am trying to find a way to fix the problem without interrupting my users every other day or so.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform