Phantom Relational Index (AREV 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]]


==== Phantom Relational Index (AREV Specific) ====
=== At 07 OCT 2005 02:34:27PM John King wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I'm trying to filecopy an Arev file from the TCL window and I get the message:



Unable to move file "DICT.ICD9_TABLE" to volume "MEDCODES"

The "ICD9_TABLE" file has relational indexes on it and the related file "DICT.ICD06" is not available or attached for updating control information.



When I do a LISTINDEX on the file there is only one crossref field being indexed.  If I remove the index it will let me copy the file but when the index gets readded and rebuilt I get the same message when copying.  I checked all other indexes and didn't see any that had relational indexes pointing to any fields of the file I'm trying to copy.  Anyone know why Arev is still thinking the file has relational indexes and is there any way to fix it?   Thanks.
</QUOTE>
----

=== At 08 OCT 2005 06:27PM Richard Bright wrote:  ===

<QUOTE>How about deleting the %FIELDS% in DICT.Table.  Then detach and reattach table.  Finally Do a RLIst of some records in table to force the rebuild of the %FIELDS%.

Richard Bright

BrightIdeas New Zealand

</QUOTE>

----

=== At 10 OCT 2005 04:40PM R Johler wrote:  ===

<QUOTE>More of a workaround than a fix:



Write a short r/basic program to select the source table, readnext/read it's records and write them to the target table.



If both source and target will be named the same, setalias (setfile) using some other name to the target temporarily.



</QUOTE>


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