--- In IBObjects@yahoogroups.com, "Svein Erling"
<svein.erling.tysvaer@k...> wrote:

> > procedure TForm1.Button1Click(Sender: TObject);
> > begin
> > IB_Query1.Open; //Opens the dataset
> > IB_Transaction1.Commit; //Closes and reopens the dataset?
> > end;
>
> The reason I suspect IB_Query1 to be reopened is this setting:
>
> > object IB_Query1: TIB_Query
> > CommitAction = caRefresh
> > end
>
> Note that I have never used CommitAction myself.
>
> HTH,
> Set

Hi Svein,

You are right !!!
This problem occurs because of "CommitAction = caRefresh" setting.
I changed with "CommitAction = caClose" and the problem disapeared.
I think these kind of problems can be solved breaking down the SP in
2: one for select and another one for update/insert.

Thanks a lot.

Jean