Subject Re: [IBO] Need help with IBOQuery / IBODatabase
Author Nando Dessena

> procedure TFrmDoctorEdit.Button2Click(Sender: TObject);
> begin
> with QryPersonEdit do
> begin
> Close;
> SQL.Clear;
> SQL.Add('Select * from person');
> SQL.Add('where person_id = :person_id');
> Params.ParamValues['Person_ID'] :=
> QryPersonListPerson_ID.AsInteger;
> RequestLive := true;
> Open;
> Edit;
> end;
> end;
> The first time that it opens, it works fine. But if you select
> another record from the first query it still opens the first record.

Looks like the Params of the internal dataset are not rebuilt upon
reconstructing the SQL, which would be a *very* strange thing. I have
several similar setups myself and they do work as expected. I must say
that I tend to use ParamByName instead of ParamValues, but that
shouldn't make any difference (it doesn't with the BDE).
Since I am interested in this type of problems, are you able to
reproduce it in a simple application (pehaps against the employee
database) for me to look into?
It may well be that you'll discover the quirk in the process of putting
together the sample app.