delphi ADOQuery多线程查询

多线程查询

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

unit uSelect;

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.



1楼 schinar 2012-04-11 20:20发表 [回复] 代码中需要加入use activex;
exeute 过程中需要修改成
CoInitialize(nil);
with FAdoquery do
begin
Close;
SQL.Clear;
SQL.Add(fsql);
Open;
end;
CoUninitialize;代码中需要加入use activex;
exeute 过程中需要修改成
CoInitialize(nil);
with FAdoquery do
begin
Close;
SQL.Clear;
SQL.Add(fsql);
Open;
end;
CoUninitialize;
.