首页 > 其他 > 详细

TDataset.CopyFields

时间:2015-02-03 12:58:03      阅读:240      评论:0      收藏:0      [点我收藏+]

Description

Often when manipulating datasets with similar structures, you need to copy the records from one dataset to another.  E.g. you may have fetched some records in a query or clientdaset and have located the matching records in another dataset.  You might then want to ensure the record values match without refetching the target dataset.
This looks like it would be easy to implement - i have rewritten it to take care of nested datasets as well as ordinary dataset fields.
Steps to Reproduce:
This is a requested new public method in the base TDataset class.
function TDataSet.CopyFields(Source: TDataSet): Integer;
// copies matching fields in current records- returns number of fields copied
var
  FieldCtr: Integer;
  DestField, SourceField: TField;
begin
  Result := 0;
  for FieldCtr := 0 to Source.FieldCount - 1 do begin
    SourceField := Source.Fields[FieldCtr];
    Field := FindField(SourceField.FieldName);
    if not Assigned(Field) then Continue;
    if Field.ClassType = TDataSetField then begin  // nested datasets
      while TDataSetField(Field).NestedDataSet.RecordCount > 0 do
        TDataSetField(Field).NestedDataSet.Delete;
      TDataSetField(SourceField).NestedDataSet.First;
      while not TDataSetField(SourceField).NestedDataSet.Eof do begin
        TDataSetField(Field).NestedDataSet.Append;
        CopyFields(TDataSetField(Field).NestedDataSet, TDataSetField(SourceField).NestedDataSet);
        TDataSetField(Field).NestedDataSet.Post;
        TDataSetField(SourceField).NestedDataSet.Next;
      end; 
    end else
      Field.Value := SourceField.Value;
    Inc(Result);
  end;
end;


This would typically be used as follows:

SourceDS.First;
while not SourceDS.EOF do begin
  if DestDS.Locate({info required to find matching record}) then begin
    DestDS.Edit;
    DestDS.CopyFields(SourceDS);
    DestDS.Post;
  end;
  SourceDS.Next;
end; 

 

 

TDataset.CopyFields

原文:http://www.cnblogs.com/cb168/p/4269551.html

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