[[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]]


==== btree.extract on .xref returning bad results (AREV Specific) ====
=== At 05 OCT 1998 02:59:55PM L. Woody Woodbury wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I have a report that performs a btree.extract on a multivalued field, AP.OPEN.XREF (which is obviously crossreferenced).  Seemingly every month or so when this report is processed, the results are incomplete. It will list a truncated group of records.  A TCL Select will give correct results and rebuilding the crossref index on AP.OPEN will also then give correct results.  What is causing the error?  Any clues?



L. Woody Woodbury

Programmer

Fulcrum InteTech

wwoodbury@fulcrumit.com
</QUOTE>
----

=== At 05 OCT 1998 03:28PM Victor Engel wrote:  ===

<QUOTE>How many hits are you talking about? Don't forget that BTREE.EXTRACT is limited to 64K of hits. If the results exceed this, it will tell you. Do you test for this condition?

</QUOTE>

----

=== At 06 OCT 1998 12:24PM Terry Rainville wrote:  ===

<QUOTE>When you make a firld XREF the computer will create an XREF

for that field with a _XREF extention.



ie.



TEST

TEST_XREF



All btree lookups must be done on the _XREF field.

</QUOTE>

----

=== At 06 OCT 1998 03:19PM L. Woody Woodbury wrote:  ===

<QUOTE>I have code to trap for 64K limit and that is not it.  And why if I rebuild the indexes does it work?  Any other ideas?

</QUOTE>

----

=== At 08 OCT 1998 10:53PM Arev 2.1 programmer wrote:  ===

<QUOTE>I've had a similar problem.  It was due to the case sensitive setting for the btree indexed field. 

</QUOTE>


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