Cross Reference Index Problem (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 08 JUL 1999 12:34:03PM Deborah Donigian wrote:

AREV Specific

Running ARev 3.1/Novell 4.1 w/NLM

We have a CUSTOMERS table with CROSSREF index on name field, and BTREE index on the city field. BTREE index works fine. The problem occurs when we try to xref on a customer name. For example, I have ten customers with the name that contain ABC (ABC Electric, ABC Grinding…) If I do a xref on ABC I will get a listing of all companies with ABC in the name. If I do the xref using ABC Electric, instead of getting that customer I will get a popup showing 'Row (#) missing' OR I will get nothing at all as though the customer does not exist in the table. This problem has just developed. I have removed all indexes for this table and recreated them. What else could be causing this problem?

Any help would be appreciated.

Deborah Donigian

At 09 JUL 1999 04:15AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:

The implication is that the index does not match the data. Otherwise I have not seen this…

amcauley@sprezzatura.com

Sprezzatura Group

World Leaders in all things RevSoft

At 09 JUL 1999 12:59PM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:

The XRef won't find ABC Electric as a single entity since each word is indexed seperately. It will find them if joined with and AND or an OR keyword (& and ; respectively).

If you need to able to find the company both ways then you'll need to BTREE the field as well.

akaplan@sprezzatura.com

Sprezzatura Group

At 10 JUL 1999 04:19AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:

Yes but AND is implicit in the B type lookup window.

amcauley@sprezzatura.com

Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...