Sorting on a calculated field, with a btree index (OpenInsight 16-Bit Specific)
At 16 JUL 2002 09:18:15AM bobyerkes wrote:
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
At 16 JUL 2002 11:30AM b cameron wrote:
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.
At 16 JUL 2002 03:46PM bobyerkes wrote:
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