Subject Re: [IBO] Problem with TIB_QUERY
Author Magno Costa
Friends. I am trying to use Cached Updates and I am not having success..

I have 2 tables, "Property" and "Talhoes."

the 2 with cached.. Then I begin the insert in "Properties", I acquire the key of the registration and I continue... then beginning to include in the table "talhoes" (before recording to "properties"), until oh everything well, I am going giving only Post in "Talhoes" while I am adding,

and in Post of the table "Properties" it follows the following commands:

DataSource1.Dataset.Post;
ChildApllyUpdates;

---------

procedure ChildApllyUpdates;
begin
inherited;
DataSource2.DataSet.ApplyUpdates; //Here the command onUpdateRecord is executed, of the dataset
DataSource2.DataSet.CommitUpdates;
Transaction1.CommitRetaining;
end;

--------

procedure IB_QueryTalhaoUpdateRecord(DataSet: TComponent;
UpdateKind: TIB_UpdateKind; var UpdateAction: TIB_UpdateAction);
begin
inherited;
case UpdateKind of
ukiInsert: begin
IB_QueryTalhao.FieldByName('COD_PROPRIEDADE').Value := idProp; //This Id I acquire at the beginning of the transaction.
end;
end;
end;

Any mistake doesn't happen, however no comita the data.

I´m using IBO 4.7, Firebird 2.0 and Delphi 2006.

If somebody can help... I thank a lot..

Hugs


[Non-text portions of this message have been removed]