Hello,
You could add a boolean (Duplicate) to the record. When inserting a
record,
you could seek for the key. If it exists already, set the bool to 'true',
otherwise false. In the filter for the GNE, you can then filter on the
boolean to be false.
Serge
"Jason Gilbert" <dev@[EMAIL PROTECTED]
> wrote in message
news:4608085d$0$14098$742ec2ed@[EMAIL PROTECTED]
> 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?
|
