Paul,

> 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.
Thanks
--
____
_/\/ando