保存WORD文件:
if OpenDialog1.Execute then
begin
if not ADOQuery1.Active then ADOQuery1.Open;
ADOQuery1.Append;
ADOQuery1fdname.Value:=ExtractFileName(OpenDialog1.FileName);
(ADOQuery1.FieldByName('fdtext') as TBlobField).LoadFromFile(OpenDialog1.filename);
ADOQuery1.Post;
end;
找开WORD文件:
if not ADOQuery1.Active then exit;
(ADOQuery1.FieldByName('fdtext') as TBlobField).savetoFile(ExtractFileDir(Application.ExeName)+ADOQuery1fdname.value);
shellexecute(handle,nil,pchar(ADOQuery1fdname.value),nil,nil,sw_shownormal);
//写入
var
MS: TFileStream;
begin
if OpenDialog1.Execute then
begin
MS:=TFileStream.Create(OpenDialog1.FileName, fmOpenRead);
MS.Position:=0;
Table1.Append;
//在数据库中添加一条记录
TBlobField(Table1.FieldbyName(’FieldDoc’)).LoadFromStream(MS);
Table1.Post;
MS.Free;
end;
end;
// 读取
var
FileSource ,FileDest : Tfilestream;
fileStrd,FileStrs:string;
F:File;
begin
with Table1 do
FileSource:=CreateBlobStream(FieldbyName(’ fieldDoc’),bmRead);
try
if savedialog1.Execute then
begin
filestrd := savedialog1.FileName;
end;
if not FileExists(Filestrd) then//如不存在新建
begin
assignFile(F,Filestrd);
Rewrite(f);
CloseFile(F);
end;