procedure TForm2.btn4Click(Sender: TObject); Var sField,sValue:string; i,j:Integer; JO:TJSONOBject; begin JO:=TJSONOBject.Create; sField:=''; sValue:=''; with mtbl_1.Delta.DataView do begin for I := 0 to Rows.Count-1 do begin if Rows.ItemsI[i].RowState=TFDDatSRowState.rsInserted then begin
for j := 0 to mtbl_1.Fields.Count-1 do begin sField:=sField+mtbl_1.Fields[J].FieldName+','; sValue:=sValue+VarToStr(Rows.ItemsI[i].GetValues(mtbl_1.Fields[J].FieldName)).QuotedString+','; end; JO.AddPair('SQL','Insert Into Person('+Copy(sField,1,Length(sField)-1)+')'+#13#10 +' Values('+Copy(sValue,1,Length(sValue)-1)+')'+#13#10) ; end else if Rows.ItemsI[i].RowState in [TFDDatSRowState.rsModified, TFDDatSRowState.rsEditing] then JO.AddPair('SQL','Edit'+#13#10) else if Rows.ItemsI[i].RowState in [TFDDatSRowState.rsDeleted] then JO.AddPair('SQL','Delete'+#13#10); end;