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


==== Aha - the real problem is ...! (OpenInsight Specific) ====
=== At 26 AUG 2000 04:26:56AM Tony Ayling wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
OK 

A whole day later

It is in fact an index on a date field that is causing the query to stop responding.  REmoving the index for the date solves the problem.  Have checked all the data and all rows have a correct internal date.



Curiously the query (Rlist statement) will function properly on the server itself.



Any Clues very welcome - have the file and query available if someone wants to play.
</QUOTE>
----

=== At 28 AUG 2000 11:05AM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Tony ..

I don't know if the old bug in AREV where the ICONV and OCONV of the date became the same.  In that case, the B-Tree became corrupted.  This was fixed in AREV 3.12 (I think, but don't hold me to it).  I wonder if OI has a similar bug.  Some time ago, I posted a report of a bug in the MOD function where the value was negative.  Particularly in doing Day-of-Week conversions when the system date was less than zero.

In this case the result came back negative and therefore couldn't be used as an index into a weekdays string.

Is it possible that one of your date entries is non-numeric (perhaps with an imbedded, non-printing character)?  This will cause a B-Tree to fail on right justified fields.  Sometimes I use a piece of code like:

C=A*1 ; * if this blows up then the data is non numeric,  The NUM test won't always reveal this.

IF A # C then .. ;* another error possibility ... for very large or very small values



Other than that, I'm stumped.



Don Miller

C3 Inc.

</QUOTE>


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