RESTORE DataBase Tsg From Disk = '直接用字符串'
////////////////////
SQL.Add( Format('RESTORE DataBase Tsg From Disk = %s',
QuotedStr(OpenDialog1.FileName));
////////////////////
SQL.Add( Format('RESTORE DataBase Tsg From Disk = %s',
QuotedStr(OpenDialog1.FileName));
解决方案 »
- delphi中的DBgrid点击数据后老是自动跳到第一行?
- 如何将XMl文件的数据导入数据库(sql/FB)?(十万火急需源代码,在线等待)
- 用命令添加自由表到数据库
- 怎样将任意格式文件保存到SQL Server中,并可以导出来?
- 问当自己的程序缩小到任务栏时触发什么消息?
- 求一Delphi7打包工具
- dxdbgrid 导出到 EXCLE 字数限制
- 关于停泊(dock)容器的autosize属性?
- 各、各、各位,救、救急!!!我弄丢了控件venus5d的密码,有谁知道吗?加分!!
- 怎样在IE浏览器中执行.EXE文件
- 如何编定开机自动运行的程序
- 谁有delphi的液晶显示时间控件,或是别的显示时间的控件提供几个?
begin
DataModule1.Free;
// DataModule1 := Nil ;
DataModule1.Database1.CloseDataSets;
DataModule1.Database1.Close;
if OpenDialog1.Execute then
begin
try
with DataModule1.lsbQuery do
begin
Close;
UnPrePare;
SQL.Clear;
SQL.Add(Format('RESTORE DataBase Tsg From Disk = %s',
[QuotedStr(OpenDialog1.FileName)])) ;
Params[0].AsString := OpenDialog1.FileName;
PrePare;
ExecSQL;
end;
except
ShowMessage('数据库恢复失败');
Exit;
end;
end;不对啊,为什么呢?
As
Exec Sp_addumpdevice 'disk','restor_de',@file_path
Restore Database databasename From restor_de
procedure Tmainfrm.Button3Click(Sender: TObject);
begin
//DataModule1.Free;
// DataModule1 := Nil ;
//DataModule1.Database1.CloseDataSets;
DataModule1.Database1.Close;
DataModule1.Database1.Connected := False;
if OpenDialog1.Execute then
begin
try
with DataModule1.lsbQuery do
begin
Close;
UnPrePare;
SQL.Clear;
//SQL.Add('backup database labor to disk=:disk with init ');
SQL.Add(Format('RESTORE DataBase Tsg From Disk = %s',
[QuotedStr(OpenDialog1.FileName)])) ;
//Params[0].AsString := OpenDialog1.FileName;
PrePare;
ExecSQL;
end;
except
ShowMessage('数据库恢复失败');
Exit;
end;
end;
//DataModule1 := TDataModule1.Create(Application);
end;
还有小菜弟啊、flayingqq,都很少来这儿了,不过,前两天见了北狼,东北人也不多见了,你说的那个笑哥哥,我估计是受不了这儿也不见来了;
你老师又那么忙,只好我帮你了,记住:请客,呵呵,今天下班我去找你把你那个改一下就可以了;
DataBase1.Connected := False;
DataBase1.Params.Clear;
DataBase1.AliasName := 'master';
DataBase1.DatabaseName := 'master';
DataBase1.Params.Add('User Name=sa');
DataBase1.Connected := True;
Query1.DatabaseName := 'master';
http://www.csdn.net/expert/topic/590/590872.xml?temp=.3634455
http://www.csdn.net/expert/topic/562/562249.xml?temp=.9288141
http://www.csdn.net/expert/topic/806/806954.xml?temp=.3521082
http://www.csdn.net/expert/topic/810/810649.xml?temp=.938534
http://www.csdn.net/expert/topic/742/742812.xml?temp=.1054041这是我以前参加过的贴子;
你们可以看一看,不是叫你们叫师哥,呵呵;