> 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