我如何将用Query查询到的数据写成Txt文件
解决方案 »
- 如何解决插入Oracle数据中文为乱码问题?
- 郁闷,新装了D2007,却不懂怎么打开原来的DPR工程文件来编辑里面的代码
- 问一个 关于在 使用 socket 做三层结构中遇到的问题!!
- 用过cxtreelist或cxgrid的请进,简单问题,高分相送^_^很急啊,谢谢相救!
- 有关饼图(pie)应用问题向大家求助!
- 急急急!请问怎么查询重复并显示的纪录?
- 使用maskedit,在输入框中有_符号,怎样不让它显示出来
- 项目合作(限北京)有意者请与我联系Delphi+sql server!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- Tquery执行返回空集?
- ADOX CATLOG.CREATE(),一句话,成功给分。
- 請問能否將三個字符賦值給一變量??
- 有关单元的问题
F:File;
i:integer;
begin
while not Query.RecordSet.Eof do
begin
for i:=0 to Query.RecordCount-1 do
Writeln(F,Query.RecordSet.Fields[i].Value);
Query.RecordSet.Next;
end;
procedure TForm14.DataSetToASCII(const ADataSet: TDataSet; const ASCIIFile: TFileName; const Delimiter: Char; const QuoteStrings: Boolean);var tmpList: TStringList;
i,LastIndex: LongInt;
AsciiRecord: String;
begin
tmpList:= TStringList.Create;
try
with ADataSet do begin
LastIndex:= Fields.Count - 1;
First;
while not EOF do begin
AsciiRecord:= '';
for i := 0 to LastIndex do
if Fields.Fields[i].Tag = 0 then begin
if QuoteStrings and
(Fields.Fields[i].DataType in [ftString,ftMemo,ftFmtMemo,ftFixedChar,ftWideString]) then
AsciiRecord:= AsciiRecord + QuotedStr(Fields.Fields[i].AsString)
else
AsciiRecord:= AsciiRecord + Fields.Fields[i].AsString;
if i < LastIndex then
AsciiRecord:= AsciiRecord + Delimiter;
end;
tmpList.Append(AsciiRecord);
Next
end
end;
try
tmpList.SaveToFile(ASCIIFile+'.txt') ;
except
ShowMessage('Could not save table to specified file: ' + ASCIIFile)
end;
finally
tmpList.Free;
end;
end;