Missing Index info on ARev imported files (OpenInsight 32-bit Specific)
At 18 MAR 2002 03:52:13AM David Kafka wrote:
I ADDED (not aliased) all the files in an ARev location. The files work, including the indexes, except that OI tells me that I have no indexed tables. (For example, if I add a record, OI can find it using the index). None of the OI indexing tools recognizes that the indexes are there, however (e.g. Database Manager List Indexed Tables finds no indexed tables.) How do I get OI to recognize that those indexes are there?
Thanks,
David Kafka
dkafka@supmat.com
At 18 MAR 2002 10:11AM Oystein Reigem wrote:
David,
What is the exact error message you get? Do a Site Search on that exact phrase. It might not have anything to do with Arev.
- Oystein -
At 19 MAR 2002 11:59PM David Kafka wrote:
Oystein,
I don't get any error message. When I ask OI to list tables with indexes, for example, it doesn't list any. If I want to delete an index in OI, none are listed to delete. If I want to do an index lookup in a Quick event, no indexes are listed. But, the !files are there, the index lookups in Basic+ or QBF work, the revmedia is normal, etc.
David
At 20 MAR 2002 07:37AM Simon Wilmot wrote:
At 20 MAR 2002 07:38AM Simon Wilmot wrote:
At 20 MAR 2002 07:38AM Simon Wilmot wrote:
David,
From my experience when we converted a few years ago, in order for the indexes to work correctly we did re-create them all in OI. We did, however, manage to see all the indexes.
It isn't just a case of not having the bang files not attached ??
Simon
RebusHR
At 20 MAR 2002 01:22PM Oystein Reigem wrote:
david,
Check what Simon suggests.
Then if no luck the following (I quote from a posting by Andrew McAuley):
"If you can't see any indexes the strong likelihood is that one of them has become corrupt. Go to the system editor and type in the exec line
run list_index
this will show you which one is broken."
- Oystein -
At 20 MAR 2002 02:02PM Mike Ruane wrote:
David-
There are also a number of Commands that can be run from the system monitor:
List_Index
List_Index_Detailed
Create_Index
Update_index
Delete_Index
and others.
We are updating the online help with these also.
Thanks-
Mike
At 28 MAR 2002 10:22PM David Kafka wrote:
Oystein,
That was it–a corrupted DICT, actually. When I ran List_Index, the listing appeared in read, and the last line was "FS" but there was no indication of which file was the problem. I found it quite by accident in ARev 3.12, then had to partially fix in ARev 1.16 because neither OI nor ARev 3.12 would allow any access at all to the file, and then I had to complete the FIXLH in OI 32 bit because ARev 3.12 broke to the debugger with Variable Exceeds Maximum length! Anyway, it works now!
By the way, thanks for your vast array of posts. I am learning a tremendous amount from you.
David
At 29 MAR 2002 11:22PM Oystein Reigem wrote:
David,
You're welcome.
- Oystein -