Database Manager / No Indexes - Yet there are (OpenInsight Specific)
At 29 JUL 1998 03:49:38PM Tom Horan wrote:
I'm in OI 3.12. I have indexes on several files. I can access these files using a index lookup and it works fine.
Problem:
When I go to DataBase manager to view/update index files, it says there are no files with indexes.
Why is this. How can I fix it..
Suggestions
At 30 JUL 1998 11:24AM Dave Pociu wrote:
Ah, yes, I remember this problem!
OK, here's what you do:
- From System Editor run this command "run list_index"
- this should get you a list of indexed tables and their index types
- More than likely, one of the tables has a problem with one of the indexes.
- Fix that problem, then try again.
- When everything looks OK here, try DataBase Manager. It should display everything
I think in one of the later releases (3.5 or 3.6 ) Cameron added a fix for this. In previous releases, as soon as an error is encountered by list_index, the Database Manager does not display anything in the index list.
Hope this does the trick.
Dave
At 30 JUL 1998 12:03PM Tom Horan wrote:
Dave,
Thanks it worked great.
At 29 OCT 1999 06:43AM Thanks, Dave Pociu wrote:
Dave,
My Database Manager suddenly wouldn't show me any indexes. But this old posting of yours helped me out.
The cause wasn't a problem with an index but a table that had no DICT. But List_Index revealed that too.
Btw - I run version 3.61, so it cannot have been fixed in 3.5 or 3.6 like you believed.
- Oystein -