I think you'd be better off telling us why you want to do this - maybe
there's a better way to achieve what you are after

Alan

> -----Original Message-----
> From: Matt Nielsen [mailto:mnielsen@...]
> Sent: Tuesday, 22 July 2003 9:19 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Key in current dataset
>
>
> 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
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>