I need to look up subsets of indexes to LH tables, e.g all index values starting with "U" in a certain index.
My first thought was to use Collect.IXVals, but Collect.IXVals will fail on indexes with very many values. Collect.IXVals tries to return *all* index values and truncates at 64K, so values at the end of the index may never be retrieved. (If only I could breed the Collect.IXVals function with the Btree.Extract subroutine I might get lucky and have offspring able to search for a subset!) (Btw - will procedure crossbreeding be possible in jRev, or will I have to wait until zooRev?) (Or till the cows come home?)
My second thought (excluding some of the above) was to beg for a piece of code that reads select parts of the index table and returns a list of index values. I'm certain it's easy to write, but I'm also certain many of you have done it already. So how about it? Please?
- Oystein -
PS. I forgot to mention that the place I need this index lookup functionality is in a web interface to LH tables, in a fairly static database. I don't know if that makes a difference.
Hi Oystein,
Have you looked at INDEXLOOKUP?
Cameron Purdy
Revelation Software
You might try this little known program.
akaplan@sprezzatura.com
Aaron,
I have. I've made a couple of functions based on the example in that article. Since I wrote the posting you responded to I've progressed a lot. I've got some help on the Works list too.
I don't yet know enough about the structure of indexes to entirely satisfy my curiosity, but I hope I know enough for my index lookup functions to work properly.
![]()
- Oystein -