D3 equivalents for SETINDEX/READFWD

67 views
Skip to first unread message

frosty

unread,
Sep 1, 2024, 8:44:31 PM9/1/24
to Pick and MultiValue Databases
Does Rocket Software's D3 product have an equivalent to teh SETINDEX and READFWD command in uniData?

If not, what's the best practice for "reversing" an index to find the Item-ID for a value in the index?

Bill H

unread,
Sep 1, 2024, 9:42:22 PM9/1/24
to Pick and MultiValue Databases
I think the KEY() function does this.  If I remember, it is easier than SETINDEX and READXFWD/BCK.

frosty

unread,
Sep 2, 2024, 11:45:22 AM9/2/24
to Pick and MultiValue Databases
Oooh... "The key statement locates an item using a B-tree index key and returns the item in a variable."
Almost exactly what I'm looking for. Presumably the Item-ID is available too.

Thank you, Bill!
Reply all
Reply to author
Forward
0 new messages