将所有表清空: procedure TForm1.FormCreate(Sender: TObject); var s:Tstrings; i:integer; begin s:=Tstringlist.Create; try database1.GetTableNames(s,false); for i:=0 to (s.Count-1) do begin Table1.TableName:=s[i]; Table1.EmptyTable; end; finally s.Free; end; end;
if Application.MessageBox('确定要删除数据吗?不可恢复!!!','严重警告',MB_YESNO + MB_ICONWARNING) = idyes then begin with ADOQuery_Csh do begin Close; SQL.Clear; SQL.Add('delete * from diary'); try ExecSQL; except ShowMessage('数据库正在被使用,初始化失败,请重新操作'); Abort; end; end; ShowMessage('数据初始化成功');
我的很多表都有触发器,如何停止所有的触发器呀?
procedure TForm1.FormCreate(Sender: TObject);
var
s:Tstrings;
i:integer;
begin
s:=Tstringlist.Create;
try
database1.GetTableNames(s,false);
for i:=0 to (s.Count-1) do
begin
Table1.TableName:=s[i];
Table1.EmptyTable;
end;
finally
s.Free;
end;
end;
begin
with ADOQuery_Csh do
begin
Close;
SQL.Clear;
SQL.Add('delete * from diary');
try
ExecSQL;
except
ShowMessage('数据库正在被使用,初始化失败,请重新操作');
Abort;
end;
end;
ShowMessage('数据初始化成功');