Subject Re: [IBO] Key in current dataset
Author Matt Nielsen
I'm doing this to prevent an InvalidateBookmark on a record that is
not displayed on the users screen for multi-user synchonization.

Basically user b made a change to the same table that user a has open
but user a might not have the record that user b changed even on his
screen so I don't need to even bother to do an InvalidateBookmark on
that record from user b.

The actually implementation get's complicated. Basically I have a
variation of the IB_SyncCursor that is available in IBO but I've
written my own to work exactly the way I need. Right now I'm doing
an InvalidateBookmark on any record changed by user b even if that
record is not even on user a's screen. I would like to prevent
this. A side effect of doing an InvalidateBookmark when it is not
needed is that you loose changes for any records that are currently
in dsEdit mode.

Hope this helps explain what I'm trying to do.

--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> 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@c...]
> > 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/
> >
> >