Indexes (OpenInsight Specific)
At 14 AUG 2000 03:41:20PM David Mayes wrote:
We have an AR 3.12 application which we have converted to OI. There are numerous Relational Indexes which update as the information changes. One index however will only update by performing a manual update or rebuild. Any ideas why that is and what I can do to fix it? It updates our cost system and it's important that the information be accurate and timely.
At 15 AUG 2000 03:18AM Simon Wilmot wrote:
David,
It could be that the index was created in ARev. I would suggest deleting the index via ARev and then re-creating the index via OI.
Regards
Simon Wilmot
Rebus Software.
At 17 AUG 2000 09:52AM David Mayes wrote:
Simon,
Thanks for the suggestion. I tried that but it will not allow me to build indexes for that table in OI. The application was developed in SYSPROG in AREV and now i can't manipulate those indexes through OI because they are not owned by the OI application. Any other ideas or thoughts?
At 17 AUG 2000 11:35AM WinWIn/Revelation Technical Support wrote:
David-
In the Arev SYSPROG application, rename the tables to be owned by the GLOBAL application- you can then manipulate the indexes from OI.
Type CW RENAMETABLE from TCL and follow the directions.
Hope it helps-
Mike Ruane