uselectsql.pas

来自「中式财务栏 表格式录入 运行时设置可显示列、列名、列宽」· PAS 代码 · 共 51 行

//==============================================================================
// 多线程查询      cxg           2008-09-26 14:29:42
//==============================================================================

unit uSelectSQL;

interface

uses
  sysUtils,ADODB,Classes;

type
  TSelect = class(TThread)
  private
    FAdoConnection:TADOConnection;
    FAdoquery:TADOQuery;
    FSql:String;
  protected
    procedure Execute;override;
  public
    constructor create(AdoConnection:TADOConnection;AdoQuery:TADOQuery;Sql:string);
end;

implementation

{ Tselect }

constructor Tselect.create(AdoConnection:TADOConnection;AdoQuery:TADOQuery;Sql:string);
begin
  inherited create(False);
  FreeOnTerminate:=True;
  FAdoConnection:=AdoConnection;
  FAdoquery:=AdoQuery;
  FSql:=Sql;
end;

procedure Tselect.Execute;
begin
  with FAdoquery do
  begin
    Close;
    SQL.Clear;
    SQL.Add(fsql);
    Open;
  end;
end;

end.