{{tag>category:"OpenInsight 32-Bit" author:"Don Pederson" author:"Oystein Reigem"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Xref lookup problem (OpenInsight 32-Bit) ====
=== At 10 MAR 2003 04:38:00PM Don Pederson wrote: ===
 
 
<QUOTE>
I have not been able to get the OR function using a ";" to work in xref lookups. According to the docs putting a semicolon between words in the search criteria should return records that have one OR the other. I.e. FL ; CA should return records with FL or CA in the field.



At first I thought it might be because I had defined ";" to be a word delimiter, but even changing that did not fix the problem.



I am using the Quick event that generates the lookup dialog box, not btree.extract.



I'm using OI 4.1.2



Don Pederson
</QUOTE>
----

=== At 11 MAR 2003 09:29AM Oystein Reigem wrote:  ===

<QUOTE>Don,



Did you se my response ? Did you understand what I wrote?



- Oystein -





</QUOTE>

----

=== At 11 MAR 2003 09:31AM Oystein Reigem wrote:  ===

<QUOTE>Don,



Sorry. The link got lost: 



- Oy -

</QUOTE>

----

=== At 13 MAR 2003 01:06PM Don Pederson wrote:  ===

<QUOTE>Yes, I did see your earlier response.  However, you were referring to the use of btre.extract, I believe.  I am simply using the quick event.



Don

</QUOTE>

----

=== At 13 MAR 2003 02:16PM Oystein Reigem wrote:  ===

<QUOTE>Don,



I made more than one reply. In one of them I pointed out that index lookup uses a particular function - for which we have the source - that in turn uses Btree.Extract. Study that function and you'll see why your effort fails. I also suggested a possible change to that function. Etc. See .



I can try to clarify or help you further if I haven't explained properly.



- Oystein -



</QUOTE>

----

=== At 20 MAR 2003 01:39PM Don Pederson wrote:  ===

<QUOTE>Oystein,



Thanks for the clarification on the Lookup function.  I think I understand how it works and what to do about it.



Don Pederson

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=A52F9D851C29D85985256CE5007157C1|View this thread on the Works forum...]]