我有2个数据一个销售主表,一个是销售明细,2个表字段数量不一样,请问如何将2个数据导出到同一个TXT文件中,字段之间分隔符是逗号。
实例:
HOH,101,1,100001,01-10-2010 10:30:20,0,1000,0
HOH,101,1,100002,01-10-2010 15:10:37,200,800,0
HOH,101,1,100003,01-10-2010 16:19:01,0,-1000,1
HOH,101,1,100004,01-10-2010 21:30:00,0,1000,0
HOT,101,1,100001,C,1000
HOT,101,1,100002,C,800
HOT,101,1,100003,C,-1000
HOT,101,1,100004,C,500
HOT,101,1,100004,B,500
实例:
HOH,101,1,100001,01-10-2010 10:30:20,0,1000,0
HOH,101,1,100002,01-10-2010 15:10:37,200,800,0
HOH,101,1,100003,01-10-2010 16:19:01,0,-1000,1
HOH,101,1,100004,01-10-2010 21:30:00,0,1000,0
HOT,101,1,100001,C,1000
HOT,101,1,100002,C,800
HOT,101,1,100003,C,-1000
HOT,101,1,100004,C,500
HOT,101,1,100004,B,500
遍历字段
写入txt
procedure TForm1.Button1Click(Sender: TObject);
var
s :string;
theStringList : Tstringlist;
i :integer;begin
theStringList:=TStringList.Create;
x.First;
s:='';
while not dataset1.Eof do
begin
for i :=0 to dataset1.FieldList.Count-1 do
begin
s:=s+dataset1.Fields[i].AsString;
end;
theStringList.add(copy(s,1,length(s)-1));
s:='';
dataset1.Next;
end; s:='';
while not dataset2.Eof do
begin
for i :=0 to dataset2.FieldList.Count-1 do
begin
s:=s+dataset2.Fields[i].AsString;
end;
theStringList.add(copy(s,1,length(s)-1));
s:='';
dataset2.Next;
end; try
theStringList.savetofile(extractfilepath(application.ExeName)+'MyData.txt');
except on e:exception do
begin
showmessage('Save TXT fail!');
theStringList.Free;
end
end;
theStringList.Free;end;
可以在最后加一句showmessage('Save to'+extractfilepath(application.ExeName)+'MyData.txt');