collect.ixvals ] 64K: How to find the first data record in an index (AREV Specific)
At 07 AUG 1999 07:52:06PM Wilhelm Schmitt wrote:
In an application with btree and xref indexed fields I would like to be able to review data-values of a large particular index (not the keys).
COLLECT.IXVALS() is ideal but breaks at 64K.
1) Is there a parameter to extend this barrier (similar to BTREE.EXTRACT)?
2) In case I have to wade through the index by program, how do I recognize the key to the !FILENAME record which holds the initial data values?
In the case of !SYSKNOWLEDGE the SEARCH_XREF values seem to start at record SEARCH_XREFROOT but in other indexes it starts at FIELDNAME_XREF.
3) The pointers in each index record are self explanatory, but how do I know that I am through with all values. On some indexes it seems to be FIELDNAME_XREF**@vm:@vm:@vm (3 value marks at the end of the key). Is that correct?
Since I have not been very succesful with the manuals, I welcome any tips or hints for further reading.
Thanks in advance
Wilhelm Schmitt
At 20 OCT 1999 04:41PM Wilhelm Schmitt wrote:
Just for the record:
Technical Bulleting TB#101 on BTREE.READ solves most questions related to accessing index values.
For more detaills: ARev Knowledge Base 'USING BTREE.READ (TB#101)' or at http://www.revelation.com/WEBSITE/knowledge.nsf/89e60900cf7ebbc8852566f500654ecb/922322b08a81d2ff852563e200499a00?OpenDocument