代码:
if odRestore.Execute then
begin
st:=FormatDateTime('yyyy-mm-dd hh:nn:ss',now);
try
with qryRestore do
begin
close;
sql.Clear;
sql.add('restore database yktxt from disk =:path WITH NORECOVERY');
qryRestore.Parameters.ParamByName('path').Value:=odRestore.FileName;
execsql;
end;
odRestore.Title:='请选择相应差异备份文件进行恢复';
if odRestore.Execute then
begin
with qryRestore do
begin
sql.Clear;
sql.Add('restore database yktxt from disk =:path WITH RECOVERY');
qryRestore.Parameters.ParamByName('path').Value:=odRestore.FileName;
execsql;
end;