Removing Quickdex (AREV Specific) [Revelation On-Line Wiki]

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

At 15 OCT 1998 01:18:04PM David Anderson wrote:

AREV Specific

I have an update that is causing me problems on several clients who have installed Quickdex on some tables. I need to have some method of determining whether or not a Quickdex exists on a table, removing it prior to installing the update and restoring it afterward.

I did catch the discussion using the QUICKDEXER subroutine but while I can use it install an index, I don't know how to use to remove an index.

Any ideas?

At 15 OCT 1998 03:33PM Jocelyn Amon wrote:

Just test for the existence of a %RECORDS% record in the file. You don't ever see this record displayed but its there if you Quickdex or Rightdex your data. It contains all the file keys. Problem is, sometimes it gets corrupt & does not always reflect the actual keys in the file (ie. too few or too many) so I never rely on it.

I thought, to get rid of the quickdex/rightdex you could just delete that record but I just tried it and got a delete protected message. I'm sure I've been able to do that in the past - must have been a different version of Arev.

At 15 OCT 1998 04:35PM Victor Engel wrote:

Testing for existence of %RECORDS% is not a reliable method for testing the existence of a quickdex or rightdex. If the index is there and has not been initialized, %RECORDS% will be absent. If the index is not there, there could nevertheless be a %RECORDS% record perhaps left by an incomplete quickdex removal process. If you can delete %RECORDS%, that is evidence that the quickdex is not installed.

Better is to open file file and check the file handle:

OPEN filename TO handle THEN
 quickdex_exist=INDEX(handle,'QUICKDEX.MFS',1)
 rightdex_exist=INDEX(handle,'RIGHTDEX.MFS',1)
END

Caveat: Above code written off the top of my head.

At 15 OCT 1998 04:49PM David Anderson wrote:

Thanks for the tips are checking for the existence of a Quickdex.

Now – how do I get rid of one through RBasic

At 16 OCT 1998 04:41AM Jonathan Bird wrote:

]]Now – how do I get rid of one through RBasic«

You would have to attach the REVMEDIA for the volume, open the revmedia record for the file, remove QUICKDEX.MFS from the second field of the record, write it back, then get all users to re-attach the file.

All of the above is relatively easy, except the last step.

J

View this thread on the forum...