procedure TxtToDB(SourceTable:TAdotable;Txtname:TFileName;fdcount:integer); //文本入数据库
var
F1:Textfile;
i:integer;
TmpStr:string;
ch:char;
begin
try
Sourcetable.Connection.BeginTrans;
try
AssignFile(F1,txtname);
reset(f1);
read(f1,ch);
while not eof(f1) do
begin
sourceTable.Append;
for i:=0 to fdcount do
begin
TmpStr:='';
while (ch<>#9) do
begin //#9 is tab
if ch<>#13 then
begin //#13 is enter
if ch<>#26 then
begin //#26 is end
Tmpstr:=TmpStr+ch;
read(F1,ch);
end else
begin
closefile(f1);
exit;
end;
end else
read(f1,ch);
end;
read(F1,ch);
SourceTable.Fields[i].AsString:=trim(TmpStr);
end;
end;
finally
closefile(f1);
end;
sourcetable.Connection.CommitTrans;
except
sourcetable.Connection.RollbackTrans;
messagedlg('导入数据失败!',mtinformation,[mbok],0);
end;
end;
var
F1:Textfile;
i:integer;
TmpStr:string;
ch:char;
begin
try
Sourcetable.Connection.BeginTrans;
try
AssignFile(F1,txtname);
reset(f1);
read(f1,ch);
while not eof(f1) do
begin
sourceTable.Append;
for i:=0 to fdcount do
begin
TmpStr:='';
while (ch<>#9) do
begin //#9 is tab
if ch<>#13 then
begin //#13 is enter
if ch<>#26 then
begin //#26 is end
Tmpstr:=TmpStr+ch;
read(F1,ch);
end else
begin
closefile(f1);
exit;
end;
end else
read(f1,ch);
end;
read(F1,ch);
SourceTable.Fields[i].AsString:=trim(TmpStr);
end;
end;
finally
closefile(f1);
end;
sourcetable.Connection.CommitTrans;
except
sourcetable.Connection.RollbackTrans;
messagedlg('导入数据失败!',mtinformation,[mbok],0);
end;
end;
解决方案 »
- 不能提权问题
- 请问如下的Delphi代码偶尔会出现指针报错的问题,是否哪里没有预防到,请高手指教。谢谢
- delphi中怎么尽量减小exe文件大小?代码长短和窗体控件大小那个关系大?
- 关于ACCESS数据字段为MEMO的显示问题
- 关于在Delphi应用程序中加载插件(重金悬赏)
- 请问:oratable 有没有类似adodataset的updatebatch??
- 关于move(buffer^,pchar(@rbuf^),bufferlength); 语句的求助
- 我有一段代码,但运行时好象总不对!请各位兄弟帮帮忙
- 各位大虾,请教一个问题,100分相送
- 用ado编的程序能在98下运行吗?
- 几个好怪的问题,大家看下呵.....
- 如何用ADO同时增加多条记录?
closefile(f1);
exit;
end;
end else
read(f1,ch);
end;
read(F1,ch);
SourceTable.Fields[i].AsString:=trim(TmpStr);
end;
end;
finally //try finally ..这里的语句是必须执行的,哪怕是出现Exit也会执行..end;
closefile(f1); //如果CloseFile()了两次,就会出现I/O错误,所以,上面的CloseFile()一个都不要
//...............................