Thanks for your reply Jason.

I found the problem. Sorry to doubt your new release. For some
reason the IndexFieldName on a few tables disappeared during the
compile and this caused the lookup failure.

I am so used to using Queries now that I forgot about the
IndexFieldName on TIBOTables when I was trying to find the reason.

Best regards

Bob

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> I would like to investigate this more.
> Can you help me reproduce this on my machine?
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: <bobzirbel@y...>
> To: <IBObjects@y...>
> Sent: Tuesday, August 21, 2001 2:00 PM
> Subject: Re: [IBO] Problem with 4.2Eb
>
>
> > Thanks for your reply Hans.
> >
> > There definitely seems to be a problem with TIBOTable.FindKey but
> > TIBOQuery.FindKey works as expected. Unfortunately I don't have
the
> > resources to convert to TIBOQuery at this time.
> >
> > Has anybody else experienced this problem or do I have a damaged
or
> > incorrectly installed version?
> >
> > Thanks in advance.
> >
> > Bob
> >
> >
> > --- In IBObjects@y..., hans@h... wrote:
> > > bobzirbel@y... wrote:
> > > >
> > > > I have just upgraded IBO to V4.2Eb on D5 with IB6.
> > > >
> > > > When I compiled and ran an existing app I found that the
FindKey
> > > > function no longer finds a key! It worked fine on IBO3.6.
> > > >
> > > > Example: Table REPORT with IBOTable tbReport. Report has a
single
> > > > field primary key.
> > > >
> > > > if tbReport.FindKey(['TESTKEY']) then
> > > > tbReport.Edit
> > > > else
> > > > tbReport.Append;
> > > > ...
> > > > tbReport.Post;
> > > >
> > > > This fails to find 'TESTKEY' even though it exists and can be
> > found
> > > > using an SQL 'where' clause, and of course the Post fails.
> > > Hello Rob,
> > >
> > > In my convertion exercise I successfully use many .FindKey(Key)
on
> > my
> > > TIBOQueries. IB4 4.2EB. I had to make sure the Key is setup in
the
> > > Keylink properties. Maybe TIBOTable is slightly different. I
choose
> > > TIBOQuery, since it converts just as easy from TTable or alike,
but
> > > it gives me right away many enhanced features and s shoehorn
into
> > TIB_
> > > native if I plan a next level conversion.
> > >
> > > Best Regards
> > > Hans
> > >
> > >
==================================================================
> > >
> > >
> > > >
> > > > I know IBOTable isn't the best solution but I am stuck with
it at
> > the
> > > > moment.
> > > >
> > > > Any help would be appreciated.
> > > >
> > > > Regards
> > > > Bob.
> > > >
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >