ApplyUpdates won't work.

[delphiman]

I am using Delphi 6 Enterprise and Interbase 6 in a 3-Tier environment.

The following works and in a grid the record actually disappears. But if I move off it (i.e. Post) and return the record is still there.

It would seem that the record is being deleted at the Client but the Application Server is not deleting it at the DataBase.

procedure IBDataSetGGChildAfterDelete(DataSet: TDataSet);
begin
IBDataSetGGChild.ApplyUpdates;
end;

Can anyone please throw some light on this?

Thanks in advance.

Terry

 

[Oppenhiemer]

Hi Terry -

Im assuming that you are refering to the ApplyUpdates to the TIBDataset component ? If so can I aask if you used the "Generate SQL" facility this component offers ?

I found that this was often the cause of un-predictable behaviour when it was used. I still use it myself - but then edit the resulting SQL so that the "Where" clause is much simpler. Make it so the "Where" clause includes only key fields and it should work.

Opp.