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.