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


==== Sorting on a calculated field, with a btree index (OpenInsight 16-Bit Specific) ====
=== At 16 JUL 2002 09:18:15AM bobyerkes wrote: ===
 
{{tag>"OpenInsight 16-Bit Specific"}}
 
<QUOTE>
I have a calculated field that had a btree index on it, when I attempt to do a select on the table with out a sort I get the correct information



When I try to sort and filter on the field it returns nothing. I removed the btree index and still had the same problem, it just took longer to process.



It's not a multivalued field and contains numeric data. There are about 14,000 small records in the table.



Any suggestions?



Bob Yerkes

elexio Software

byerkes@elexio.com
</QUOTE>
----

=== At 16 JUL 2002 11:30AM b cameron wrote:  ===

<QUOTE>If you just LIST tablename YOURCALCCOLUMN do you get the proper results? If you LIST with criteria against the calc. field are the

results good?  Is it possible that you have a  item id or an item id that has low or high char value characters in it?  That can

mess up the !file and give erroneous results.  Just some thoughts.

</QUOTE>

----

=== At 16 JUL 2002 03:46PM bobyerkes wrote:  ===

<QUOTE>I was thinking the same thing and checked for strange char's and null entries.



After spending a large portion of my day trying to figure it out, I found that it had really nothing to do with the btree index. It was a group format error on SYSLISTS that was causing the problems.



Thanks for the help.



Bob Yerkes

elexio Software

byerkes@elexio.com

</QUOTE>


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