首页 > Web开发 > 详细

FDMEMTABLE将修改后的数据序列为JSON

时间:2019-03-31 12:44:55      阅读:316      评论:0      收藏:0      [点我收藏+]

FDMEMTABLE将修改后的数据序列为JSON

procedure TForm1.Button3Click(Sender: TObject);
var
  memtable: TFDMemTable;
  ms: TStringStream;
begin
  memtable := FDMemTable2;
  memtable.CachedUpdates := True;
  if memtable.State in dsEditModes then
    memtable.Post;
  if memtable.ChangeCount = 0 then
    Exit;
  memtable.ResourceOptions.StoreItems := [siDelta, siMeta];
  ms := TStringStream.Create(‘‘, TEncoding.UTF8);
  try
    memtable.SaveToStream(ms, sfJSON);
    Memo1.Text := ms.DataString;
  finally
    ms.Free;
    memtable.ResourceOptions.StoreItems := [siDelta, siMeta, siData];
  end;
end;

  JSON字符串如下:

{
	"FDBS":
	{"Version":15,"Manager":{"UpdatesRegistry":true,
		"TableList":
		[{"class":"Table","Name":"qryOpen","SourceName":"tunit","SourceID":1,"TabID":0,"EnforceConstraints":false,"MinimumCapacity":50,"CheckNotNull":false,
			"ColumnList":
			[{"class":"Column","Name":"unitid","SourceName":"unitid","SourceID":1,"DataType":"AnsiString","Size":4,"Searchable":true,"Base":true,"OInUpdate":true,"OInWhere":true,"OInKey":true,"OriginColName":"unitid","SourcePrecision":4,"SourceSize":4},
			 {"class":"Column","Name":"unitname","SourceName":"unitname","SourceID":2,"DataType":"AnsiString","Size":6,"Searchable":true,"AllowNull":true,"Base":true,"OAllowNull":true,"OInUpdate":true,"OInWhere":true,"OriginColName":"unitname","SourcePrecision":6,"SourceSize":6}
			],"ConstraintList":[],"ViewList":[],
			"RowList":
			[{"RowID":1,"RowState":"Deleted","Original":{"unitid":"12","unitname":"双"}},
		     {"RowID":2,"RowState":"Inserted","Current":{"unitid":"13","unitname":"中"}},
             {"RowID":0,"RowState":"Modified","RowPriorState":"Unchanged","Original":{"unitid":"11","unitname":"个"},"Current":{"unitid":"11","unitname":"测"}}
			]
		 }
		],"RelationList":[],"UpdatesJournal":{"SavePoint":2,"Changes":[{"TabID":0,"RowID":1,"ChangeNumber":0},{"TabID":0,"RowID":2,"ChangeNumber":1}]}}
	}
}

  

  

FDMEMTABLE将修改后的数据序列为JSON

原文:https://www.cnblogs.com/hnxxcxg/p/10630727.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!