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.

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 [email protected])

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.

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

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

View this thread on the forum...