Some help with Interbase6 - ThinClient please.

[delphiman]

I am using Delphi 6 Enterprise and Interbase 6.

I have a working 3-Tier model in which I am able to manipulate and update data from the
1st ThinClient which is located on the same machine as the Applicationserver and the DataBase.

MY PROBLEM

I need to manipulate certain data LOCALLY - as accessed by the ThinClient - which
manipulations are themselves dependant upon certain UpDates taking place WITHIN THAT BATCH
and BEFORE the required (and final) UpDates (all-round) can be performed on the DataBaseServer
itself.

But I find that any (locally required interim) UpDates in the ModifySQL of IBDataSet don't
take place unless and until I come out of the ThinClient and/or LogOff from the
ApplicationServer.

Can someone please give some ideas as to how I might handle this and as to why the UpDate
code in the ModifySQL of IBDataSet does not have a CONSTANT "real-time" effect?

Thanks in advance.

Terry.

 

[delphiman]

For those following this thread I have found the following does the trick.

procedure TfrmFather.btnUpdChildClick(Sender: TObject);
begin
ParentDM.IBdsTrnsfr.ApplyUpdates;
ParentDM.IBFatherDataSet.ApplyUpdates;
ChildrenDM.IBdsChild.ApplyUpdates;
GChildrenDM.IBdsGChild.ApplyUpdates;
GGChildrenDM.IBdsGGChild.ApplyUpdates;
end;