General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only