I just found that Findkey returns true for values that are filtered out.  Is this the intended behavior or a bug?

I use FindKEY to locate a record and then show the Edit window.  With DBISAM, this worked as I intended, but with Elevate DB, it returns true, which means the the edit record contains the incorrect row.

To overcame this, I had to do this:

Change from:
       if FindKey([Px]) then
       begin
To:
       if FindKey([Px]) and (FieldByName('ID').AsInteger=Px) then
       begin

NOTE: The ID in Px exists in the database, but it's a filtered dataset.

Thanks,
Pierre

Hello Folks,

Anyone else experiencing this?  Is this intended behaviour?

Many thanks,
Pierre

Pierre,

<< I just found that Findkey returns true for values that are filtered out.
Is this the intended behavior or a bug?

I use FindKEY to locate a record and then show the Edit window.  With
DBISAM, this worked as I intended, but with Elevate DB, it returns true,
which means the the edit record contains the incorrect row. >>

I'll check this out and if it is an issue, it will be fixed in the next
build 18.  If I can't reproduce it, I'll follow up with you here.

--
Tim Young
Elevate Software
www.elevatesoft.com

Pierre,

What version/build are you using ?  I can't replicate this with 2.03 B17:

procedure TForm1.Button1Click(Sender: TObject);
begin
  EDBTable1.Filter:='State=''FL''';
  EDBTable1.Filtered:=True;
  if EDBTable1.FindKey([1354]) then
     Label1.Caption:='Found'
  else
     Label1.Caption:='Not Found';
end;

shows "Not Found" every time, which is correct.

--
Tim Young
Elevate Software
www.elevatesoft.com

>> What version/build are you using ?  I can't replicate this with 2.03 B17:

Hi Tim,

I think the problem lies with the fact that I also use the "OnFilter" event.  I use a combination of setting the filter, as well as the OnFilter event.  I'm using the latest build.

Many thanks,
Pierre

Pierre,

<< I think the problem lies with the fact that I also use the "OnFilter"
event.  I use a combination of setting the filter, as well as the OnFilter
event.  I'm using the latest build. >>

Ahh, okay, let me check that out and get back to you.

--
Tim Young
Elevate Software
www.elevatesoft.com