[[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]]
==== Cross Reference Index Problem (AREV Specific) ====
=== At 08 JUL 1999 12:34:03PM Deborah Donigian wrote: ===
{{tag>"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 [i]implication[/i] is that the index does not match the data. Otherwise I have not seen this...
amcauley@sprezzatura.com
[url=http://www.sprezzatura.com" ]Sprezzatura Group[/url]
[i]World Leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== 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
[url=http://www.sprezzatura.com]Sprezzatura Group[/url]
[img]http://www.sprezzatura.com/zz.jpg[/img]
----
=== 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
[url=http://www.sprezzatura.com" ]Sprezzatura Group[/url]
[i]World Leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=B3C219E5992BD762852567A8005B026A|View this thread on the forum...]]