Posts

Showing posts with the label firedac

TFDTable edit fails with Firebird 2.5.7 not 2.5.3

Image
Clash Royale CLAN TAG #URR8PPP TFDTable edit fails with Firebird 2.5.7 not 2.5.3 This code: FDConnection.Open; // Design time TFDConnection; default settings TabelGrid.Close; // TDFTable connected to TFDConnection; default settings TabelGrid.TableName := 'TT_ACT'; TabelGrid.Open; TabelGrid.Edit; TabelGrid.FieldByName('TT_NAME').AsString := TabelGrid.FieldByName('TT_NAME').AsString + '*'; TabelGrid.Post; fails with [FireDAC][Phys][IB]-312 Exact update affected [0] rows, while [1] was requested when Firebird 2.5.7 is installed, not when Firebird 2.5.3 is installed. Call stack: Conditions: TFDConnection sysdba TFDPhysIBDriverLink TFDPhysFBDriverLink The table has 3 indices: TT_I0_ACT TT_ACT_ID Primary TT_I1_ACT TT_PARENT_ID TT_I2_ACT TT_FROMDATE I've fumbled with settings, especially changing the default UpdateOptions.UpdateMode s from UpWhereKeyOnly to UpWhereChang...