index tables not available (OpenInsight Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== index tables not available (OpenInsight Specific) ====
=== At 08 SEP 1999 08:26:58AM Brian Braybrooke wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
I have an app which saves data into archive sets, each stored in their own directory.  When connecting to an archive, I detach all the original tables, then connect to the archive tables using alias_table, as the archive tables are all prefixed with an "A".

Some of the tables have indexes, but no matter what I do I cannot use them.  They appear correctly in Database Manager's LH Table Info, but when code tries to access the tables on an indexed field I get the error 'FS100: record "!ACOURSE" does not exist'.

I have tried updating and rebuilding the indexes, which gives no errors, and have tried the utility SYNCDB but that finds no errors.

There is no entry for "!ACOURSE" in the apps .DBT file.

Any ideas?
</QUOTE>
----

=== At 23 SEP 1999 09:16AM Brian Braybrooke wrote:  ===

<QUOTE>In case anyone is interested, I have found a solution to this problem.

Before copying tables into another directory, all indexes on those tables must first be removed.  Then copy the tables, then finally create the indexes on both the original and the copied tables.

Rather than use list_index() (very slow!) I instead created a table detailing all indexes within the application, then search through this table for the indexes to delete then (re)create.

I hope this is useful for someone...

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=E316C896B66D18ED852567E600446319|View this thread on the  forum...]]