procedure TForm1.Button1Click(Sender: TObject);
var
fileN: TextFile;
i: integer;
str: string;
begin
try
AssignFile(fileN,'c:\test.txt');
if not FileExists('c:\test.txt') then
rewrite(fileN);
Query1.open;
Query1.First;
while not Query1.Eof do
begin
str := '';
for i := 0 to Query1.FieldCount - 1 do
str := str + Query1.Fields[i].AsString + ' ';
Append(fileN);
Writeln(fileN,str);
Query1.Next;
end;
finally
CloseFile(fileN);
end;
var str:string;
i:integer;
begin
While not Query1.Eof do
begin
Str:='';
For i:=0 to Query1.Fields.Count-1 do
begin
Str:=Str+Query1.Fields.Fields[i].DisplayName+': '+Query1.Fields.Fields[i].AsString+' ';
end;
str :=str+chr(13); //换行
Memo1.Lines.Add(Str);
Query1.Next;