Index record '<file_name>.xref' has been deleted.

Index for "<file_name>.xref" should be rebuilt.

I am using revelations version -Rev G. This is the error message I receive when I attempt to do a lookup for a field in the file. I have attempted to rebuild the index - which is successful, but I get the same message(as above). I have over 20,000 records in the file. The lookup field is just a seven-digit member number. Any suggestions of what might be wrong.

Thanks in advance. Travis

willts@netzero.net

the XR record is stored in the RDES file. it appears your screen may have changed

to see all of the XR items in your application try

LIST RDES "[XR]"

Rwilson,

I have attempted your command and it displays a message requesting a filename. I am using Advanced Revelations (menu-based with TCL option - DOS program). I do see the record in RDES using the command below. Could my file be corrupt? I created this cross reference index by using menu options under AREV. Some records that I lookup do appear and others for some reason do not. This lookup is under a data entry screen. I think you are correct something needs to be updated - I am just not certain which file.

LIST RDES <FILENAME> "[XR]"

If you are using Arev then the RDES file probably doesn't exists. they switch to using PAINT as the screen processing program beginning with Arev.

from TCL type in WHO and if you see something like "User SYSPROG, level 1, station ?" then you

are using Rev G2b, anything else should show you release level/ amount of memory etc.

You are correct. The user is SYSPROG with the following info.

Release Version: 1.0

AccountName: Sysprog

Station ID: 0

Restriction Level: <blank>

I guess the only way to test the index is to create a test data entry screen. The current data entry screen gives me the error as previously indicated. What doesn't make sense is that I have multiple cross reference indices and they all work except for the one.

WOW arev 1.0, I don't remember arev being stable until at least 1.16

what do you seen when you f10 then tools/files/indexing

does your file show up and do the fields for that file show indexed

if so a simple select or list'sort with one of the indexed fields should

display something about using index

in my system SELECT HOURS WITH DATE GE "1.1"

shows something like "satisfying select with ….."

When I select Tools → Files → Indexing, I have menu that displays Btree, Cross Reference, Relational, Update List Index. This is the menu where I created my cross reference indices for the file (aka. table). The fields for the file does display a corresponding index. I can select the cross reference index (via TCL) and I do see the cross reference field values with no problem under TCL . Furthermore, I have done lookups under TCL (i.e. SELECT MEMBERS MEMBER.NO.XREF "4490153") with no problems. The problem is when I attempt to retrieve the one cross reference field value through a data-entry screen (via. Ctrl+F10 → Indexed Fields → member.no.xref ). It only happens for certain values within this table (i.e. MEMBERS). I may need to rebuild the table.

Example

Table :MEMBERS

Fields:Member.no,Store.no, Lastname

Cross Reference field: Member.no.xref (7 digit), Store.no.xref (2 digit), Lastname.xref (string)

Member.no.xref only works up to a certain part of the table, because when I attempt to lookup member numbers through the data screen it displays the message. TCL lookup work fine for all cross-reference values.

Perhaps you have a key value in the file that contains one or more Revelation delimiters.

This will cause your index tree to misalign. Write yourself a little utility to look through

each key and check for Revelation delimiters. If found, you would change that key to remove

the delimiter and report it to be examined. Then, do a re-index.

Dave Harmacek

Harmacek Database Systems

Dave,

I could not find any Revelation delimiters within the file/table keys. I have noticed that if I start modifying the cross reference Relation delimiters (i.e. VM, SVM, etc). I can successfully look up member numbers I have not looked up previously; however, other member numbers still give the same error message. My test file only consisted of 130 records.

Travis

Dave,

I could not find any Revelation delimiters within the file/table keys. I have noticed that if I start modifying the cross reference Relation delimiters (i.e. VM, SVM, etc). I can successfully look up member numbers I have not looked up previously; however, other member numbers still give the same error message. My test file only consisted of 130 records.

Travis

What is in the MEMBER.NO field?

Is it just a listing of member numbers?

Is it single or multi valued?

It doesn't sound like you need a cross reference on this field at all, just a btree.

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

View this thread on the forum...