Add an index in 8.0.8 (OpenInsight 32-bit)
At 20 JUL 2012 05:02:06PM Mike ONeal wrote:
Hi all
I am unable to *add* any indexes via Database Manager → Utilities → Indexes on an 8.0.8 system because a list of available tables are not presented in the drop-down window. The drop-down opens but it is completely blank. *Remove* *Update* and *List* all display tables, and I can remove and update indexes. I have rebuild the .dbt with no success.
Any ideas? Thanks much,
Mike O.
At 24 JUL 2012 08:45AM Jared Bratu wrote:
If you log into SYSPROG and tried to add a new index to an existing SYSPROG table does the same problem occur? I'm trying to determine if it's related to your application or the list of attached tables.
If you aren't able to see the list of tables when logged into SYSPROG then try replacing your SYSPROG.DBT with a fresh SYSPROG.DBT and try again. If this resolves the problem then your applications DBT file may be damaged and need to be rebuilt.
At 24 JUL 2012 09:39AM Mike ONeal wrote:
Jared, I can add indexes in the SYSPROG account. Just to confirm then, this is a problem with our application .dbt. To rebuild that, I make a copy of the SYSPROG.DBT, re-name it to our application name, log in to our application, then start attaching the tables. Is that the correct sequence?
Thank you,
Mike O.
At 24 JUL 2012 05:14PM Jared Bratu wrote:
That is the process. I suggest you try starting with your problem tables first, there is a chance the problem could be with a particular table but I think it's related to the DBT.