No columns are indexed but they are - redux (AREV Specific)
At 10 JUN 2009 11:10:09AM James Foulkrod wrote:
Similar but not the same as a post by Michael Slack in 2001 - I converted an app to AREV32. Before converting I removed the indexes from a table - SALESORD. After converting I added the indexes. The table doesn't show up in the ListIndex display. When I look at each index definition using the Btree, Cross Ref, etc. forms they are correct. I try to Update or Rebuild the indexes I get the B173 msg "No columns are indexed in SALESORD". SI.MFS shows on the LISTVOLUME display for the table. SALESORD, DICT.SALESORD, and !SALESORD are on the same volume and belong to the same app. The
!SALESORD table media is REV21141.OV & LK and they contain over a meg of data between them.
How can I see if the indexes are actually working ok? Maybe I don't really have a problem.
Do I need to remove and re-add the indexes and if so do I have to do it manually?
Thanks,
Jim
At 10 JUN 2009 11:26AM James Foulkrod wrote:
Update: I think the indexes are working because a field in SALESORD is being filled in by a relational.
At 10 JUN 2009 02:10PM Dave Harmacek wrote:
Assuming you did a Database Save.
Did you then exit the Database Manager, then re-enter it. Then checking ListIndexes?
At 10 JUN 2009 03:43PM Jared Bratu wrote:
To remove indexes manually please follow The KB article Removing Indexes Manually in OpenInsight. It will walk you through removing them at a very low level so please backup your system before attempting this procedure.
At 11 JUN 2009 09:29AM James Foulkrod wrote:
Hi Dave,
I've done all this index work in the AREV32 Standalone form environment. Should I go to OI and do a Database Save?
Jim
At 11 JUN 2009 10:16AM Dave Harmacek wrote:
I believe you should no longer use the indexing Creation/Remove features of Arev32. Use the Database Manager and subroutines in OpenInsight.
The system maintains a .dbt file that has the details of the filing system for that "application". When you start Arev32 it reads that file.
In fact, if in the OI session you temporarily attach a table, it is not available to an existing Arev32 session since they use separate Oengines. SETALIAS works within the Arev32 session just fine, but a separate OI session doesn't know about that, either.
At 11 JUN 2009 12:51PM James Foulkrod wrote:
Thanks Dave.
Should I remove all indexes that I created in AREV32 and re-create them in OI?
Jim