Missing indexed tables info in Tools, Database, Utilities, Indexes (OpenInsight Specific)
At 25 JUN 2001 09:33:05PM Eduardo Murphy wrote:
An OI application that otherwise works fine has lost the ability of showing all indexed tables (and its details) when one looks for them thru the menu Utilities, Index in the Database Management tool. So it would be also impossible to delete or update indexes that way, although it remains possible to do all that using the command line in System Editor ("RUN DELETE_INDEX …" etc).
As said, everything else is OK in the same application: indexes do exist and work, and so on, as long as one can see.
How could I fix this? Could this be a symptom of something worse?
At 26 JUN 2001 02:59AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Try going to the system editor and typing in the EXEC line RUN LIST_INDEX. A listing will appear and then stop with a red line. This is the index which has problems - fix this and the problem will go away.
World Leaders in all things RevSoft
At 26 JUN 2001 05:08AM Oystein Reigem wrote:
Sprezz, Eduardo,
A few days ago I had the same symptom under different circumstances. I could get rid of the symptom by detaching all 46 tables in one particular location, and not attach all of them again at the same time, e.g only half of them at a time. My experiments indicated there wasn't one particular table causing the problem.
E.g when I attached half of the tables at a time I don't remember if I saved the database definition inbetween. So I don't know if it was attaching a lot of tables or saving the database definition with a lot of new tables that caused the problem.
The total number of (data) tables in the app was also fairly large - 167. I don't know if that has anything to do with the problem.
- Oystein -
At 26 JUN 2001 10:26AM Eduardo Murphy wrote:
In my case there are not many attached tables (about a dozen), but there was plenty of creating and/or deleting tables. In fact, I have some other questions to pose, but I will submit them as separate topics looking for a better discussion.
I had already tried RUN LIST_INDEX with no parameters and, yes, it had ended with a reference to the dict of a table that I had deleted some time ago. I will try to make it disappear.
Thank you.