[[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]]


==== Manually removing an Index in Arev 3.03 (AREV Specific) ====
=== At 13 JAN 2000 07:52:11PM Kevin C. wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Greetings -



I'm trying to manually remove an index and recreate it, on an Arev 3.03 table (following instructions from the TB), but after I do a deletetable on the ! file, and remove the appropriate fields from the dictionary, I'm unable to create a new index on the table, because it says the ! file already exists.



I noticed that the ! file still shows up in the revmedia listing as well, even after it supposedly was deleted.



Any ideas are greatly appreciated !





Kevin C.
</QUOTE>
----

=== At 13 JAN 2000 10:48PM Kevin Gray - Graycorp wrote:  ===

<QUOTE>This has occurred with some of our clients on odd

occassion - rarely though.



How we overcome it is to trick the system by creating

a BTREE index on a single column within the data table.



This re-creates the index table.



Perform a rebuild on the table using the indexing menu.



Next step is to use the indexing menu to remove all

indexing from the table ..... do not delete manually!



In most instances this does the job.



If it does not work then you have a difficult next stage

that we will not detail at this time.



If you have trouble then happy to exchange e-mail on the

topic.



By then other posts may well cover that next step which

revolves around using the operating system level methods.



Not something you want to mess with except with extreme

caution.



Kind regards,

Kevin Gray

Graycorp

(email kevin@graycorp.com.au)

</QUOTE>

----

=== At 14 JAN 2000 09:09PM Donna wrote:  ===

<QUOTE>I do this. 



Remove all indexing from the file

Type clearfile !filename  (be sure the ! is in front of the filename)

Log to Sysprog 

Attach Revmedia

Edit Revmedia

Find the file and delete it 



Relog and it will be all gone

This will allow you to set up new indexing and it will give you 

a new file number. 









</QUOTE>

----

=== At 20 JAN 2000 12:04PM KevinC wrote:  ===

<QUOTE>Thanks - this worked fine, and we're back up and running!



Now I need to post another question to the Arev community, regarding Citrix  :-)



</QUOTE>


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