Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index file is in use; .cdx
Message
From
31/07/2006 15:14:16
 
 
To
31/07/2006 15:00:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01141821
Message ID:
01141902
Views:
18
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform