unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, StdCtrls, Grids, DBGrids, RzDBGrid, ExtCtrls;
type
TForm1 = class(TForm)
Panel1: TPanel;
RzDBGrid1: TRzDBGrid;
Button1: TButton;
ADOConnection1: TADOConnection;
ADOQuery1: TADOQuery;
ADOtrigger: TADOQuery;
DataSource1: TDataSource;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TForm1;
implementation
{$R *.dfm}
procedure TForm1.Button1Click(Sender: TObject);
var
I: Integer;
S: string;
begin
with TStringList.Create do try
LoadFromFile('trigger.sql');
S := '';
for I := 0 to Count - 1 do begin
if SameText(Trim(Strings[I]), 'GO') then begin
ADOtrigger.Close;
ADOtrigger.SQL.Clear;
ADOtrigger.SQL.Text := S;
ADOtrigger.ExecSQL;
//ShowMessage(S);
S := '';
end else S := S + Strings[I] + #13#10;
end;
if S <> '' then
begin
ADOtrigger.Close;
ADOtrigger.SQL.Clear;
ADOtrigger.SQL.Text := S;
ADOtrigger.ExecSQL;
//ShowMessage(S);
end;
finally
Free;
end;
RzDBGrid1.DataSource.DataSet.Delete;
end;
end.
Delphi执行SQL脚本
最新推荐文章于 2017-06-11 09:03:00 发布