Btree problem (OpenInsight 32-bit Specific)
At 17 NOV 2003 12:26:09PM jay o rappaport wrote:
wondering what i am doing wrong.
have an index on a field that is numeric ranging form 1-2000.
if i do a btree.extract of
field:@vm:'1000…1010':@fm
i get a correct result.
on the other hand, when i try
field:@vm:'100…110':@fm
what i get are not only those record with a value of 100-110 BUT
also 1000-1010. it would seem that the btree extract is doing a partial match of the value.
anyone every see this and is there a workaround. this also has created a problem when doing extract on dollar values, searching seems to be doing partial matches that make no sense at all. a search of a value in the rand 180,000,000 to 190,000,000 also return values in the range of 180,000 to 190,000 etc.
I did try and delete and rebuild the indexes with no improvement.
tia
At 17 NOV 2003 12:26PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Our initial response would be to check the justification of both the dictionary item and the corresponding index entry in the ! table. You seem to be experiencing alphabetic rather than numeric sorts.
World Leaders in all things RevSoft
At 17 NOV 2003 12:26PM jay o rappaport wrote:
duhhhhhhhhhhhhh
thanks – figures it would be something real dumb that i should have known better about
jay
At 17 NOV 2003 12:26PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
S'ok -we still see clients being caught by searching on dates in "internal" form that gets interpreted as "external form"
World Leaders in all things RevSoft
At 17 NOV 2003 12:26PM [email protected] wrote:
is the dict right justified?