Aha - the real problem is ...! (OpenInsight Specific)
At 26 AUG 2000 04:26:56AM Tony Ayling wrote:
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.
At 28 AUG 2000 11:05AM Don Miller - C3 Inc. wrote:
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.