procedure Tfrmdataback.FormCreate(Sender: TObject); var SourcePath:string; path:string; begin Self.Caption:=application.Title+'-数据备份'; //B_Showmessage:=true; SourcePath:=ExtractFileDir(Application.ExeName); //取得应用程序路径 if ForceDirectories(sourcepath) then begin if(StrLen(PChar(SourcePath))<>3)then SourcePath:=SourcePath+'\' ; path:= SourcePath+'数据备份' ; if ForceDirectories(path) then begin Edit1.Text:=path+'\'+'gctj'+formatdatetime('yyyymmdd',date)+'.back'; //设置路径+文件名 end; end end;procedure Tfrmdataback.Button2Click(Sender: TObject); begin self.Caption :='正在备份数据.......'; dm.cback.CommandText:='backup database gctj to disk='''+edit1.Text+''''; //备份语句 try dm.cback.Execute;//执行备份 showmessage('备份成功'); except showmessage('备份失败'); end; self.Caption:='数据备份'; end;
const
cnBackUpCommand = 'BACKUP DATABASE [%s] TO DISK = N%s ' + 'WITH INIT ';var
FDataBaseName: string;
sBackUpCommand: string;
sFileName: string;begin FDataBaseName:=edit1.text;
sFileName := ExtractFilePath(Application.ExeName) + 'backup' + '\' + edit1.text;; sBackUpCommand := Format(cnBackUpCommand,
[FDataBaseName,
QuotedStr(sFileName)]);
ADOQuery1.Sql.Text := sBackUpCommand;
try
try
ADOQuery1.ExecSql;
except
raise;
Exit;
end;
finally
ADOQuery1.Close;
end; MessageDlg('备份成功!', mtInformation, [mbOK], 0);
end;
var
SourcePath:string;
path:string;
begin
Self.Caption:=application.Title+'-数据备份';
//B_Showmessage:=true;
SourcePath:=ExtractFileDir(Application.ExeName); //取得应用程序路径
if ForceDirectories(sourcepath) then
begin
if(StrLen(PChar(SourcePath))<>3)then
SourcePath:=SourcePath+'\' ;
path:= SourcePath+'数据备份' ;
if ForceDirectories(path) then
begin
Edit1.Text:=path+'\'+'gctj'+formatdatetime('yyyymmdd',date)+'.back';
//设置路径+文件名
end; end
end;procedure Tfrmdataback.Button2Click(Sender: TObject);
begin
self.Caption :='正在备份数据.......';
dm.cback.CommandText:='backup database gctj to disk='''+edit1.Text+'''';
//备份语句 try
dm.cback.Execute;//执行备份
showmessage('备份成功'); except
showmessage('备份失败'); end;
self.Caption:='数据备份';
end;
将数据备份改成backup