I'm writing a program that uses a Get Next Extended to pre-load position
information about records in a fairly-large database by loading x number
of records at a time. This works pretty well performance-wise, except
that I only want to retrieve unique keys instead of every record. The
filters on Get Next Extended can filter on static values or on values
within the record, but I don't see a way to be able to filter on
something like "greater than previous record retrieved" or something
like that. The alternative of looping through the keys one at a time
seems like it would be too slow.
Can anybody think of a way to achieve something like this?
