Re: Equivalent of Get Next Extended to retrieve only unique keys?

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@xxxxxxxxxxxxxx> wrote in message
news:4608085d$0$14098$742ec2ed@xxxxxxxxxxxxxxxxx
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?


.

Relevant Pages

  • Re: Boolean and Xkeyval
    ... .and for each one I defined one boolean. ... the value of of the boolean grid of B to the boolean grid of A. ... separated list of all keys that shall be ignored during the ... "Lists in TeX's Mouth", ...
    (comp.text.tex)
  • Re: [PHP] POST/GET into variables
    ... and then make them all into variables with their names being the keys ... to the get/post, and their values as the variables values. ... if you are writing a class to filter data in the $_POST ... private static function filterArray{ ...
    (php.general)
  • Re: [PHP] POST/GET into variables
    ... im just trying to clean the post/gets and then make them all into variables with their names being the keys to the get/post, and their values as the variables values. ... the decision youll have to make is this; will this class simply act as a filter for these ... private static function filterArray{ ...
    (php.general)
  • Re: Keyboard filter driver for the multimedia and power keys on a usb keyboard.
    ... you would filter the appropriate collections based on the hw ID ... for the power button, you should do the same as PS2 ... > What I have is a keyboard with the multi-media keys. ... > ULONG caps; ...
    (microsoft.public.development.device.drivers)
  • Re: *** Keyboard Input Problems after upgrading from XP Home to Pr
    ... run the driver install again... ... > My Filter and Sticky keys were turned off, ... >> inputting chars using my keyboard. ...
    (microsoft.public.windowsxp.general)