Hi guys,
I have this situations :
- Use IBX for database operations
- Use TIBDataset with CacheUpdate Enabled
I have an TDBEdit, with value = 'abc', then edit its value to 'abcde'
To Update database, I clicked Save button, which codes something like this
procedure TForm1.btnSaveClick(Sender: TObject);
var
Tbl : array [1..1] of TDataSet;
begin
Tbl[1] := Dt;
Dba.ApplyUpdates( Tbl);
ShowMessage('saved');
end;
That code works OK when network connection is OK, database value updated to 'abcde', but when network connection is lost, Dialog box showed with error message and option to click OK or Abort.
Error reading data from connectionThat error was expected, if users click Abort, app closed, if user click OK, app not closed, value of TDBEdit in the screen still 'abcde'.
Problem is, when network connection restored again while app still open/ not restarted again, clicked again button Save still got same error like above.
Is IBX able to save data to the data when network connection is restore again without need to restart the app?