I actually already have the the dataset open and want to determine if
a specified key exists in the dataset that is already open.

for instance I have a table that has key values

1
2
3
4
5
6
7
8
9
10

I have a dataset that has key values of

3
5
9
10

I want to be able to determine if Key value 1 or 4, etc is in this
dataset whithout having to iterate through the records and move the
record position.

Thanks,

Matt

--- In IBObjects@yahoogroups.com, Lester Caine <lester@l...> wrote:
> > Is there a way to determine if a key value exists in a specified
> > dataset without scanning through the records. Possibly using
> > something similar to the KeyFields property?
>
> IB_DSQL with a select in?
>
> SELECT KEY FROM TABLE WHERE KEY = :KEY
>
> I use it all the time.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services