Mega Search
23.2 Million


Sign Up

Make a donation  
TFDDataMove raises exception 'not implemented'  
News Group: embarcadero.public.delphi.database.firedac

Hi,

I'm working with TBatchMove to Transfer the data from one dataset to another.

if i am setting the TBatchMove.Mode = dmAlwaysInsert. It's only doing the insertion.

my problem is here. i need to do the dual process (insertion,updation) between datasets.

so i set the TBatchMove.Mode = dmAppendUpdate. but while updation i am always getting the error


procedure TForm1.Button1Click(Sender: TObject);
begin
  FDQuery1.Close;
  FDQuery1.Open;
  FDQuery2.Close;
  FDQuery2.Open;
  FDBatchMove1.Mode := TFDBatchMoveMode.dmAppendUpdate;
  FDBatchMove1.Execute;

end;

procedure TForm1.FDBatchMove1FindDestRecord(ASender: TObject;
  var AFound: Boolean);
var
  Value : Variant;
begin
     Value := FDQuery2.FieldByName ('BRANCHCODE').AsString;
     AFound :=  FDQuery1.Locate ('BRANCHCODE', Value);
end;



'[FireDAC][Phys][FB]-312. Exact update affected [0] rows, while [1] was requested'.

Please help me on this problem.

Thanks in Advance.

Udhayakumar M.
Vote for best question.
Score: 0  # Vote:  0
Date Posted: 2-Jun-2015, at 1:06 AM EST
From: Udhayakumar M