Mega Code Archive

 
Categories / Delphi / ADO Database
 

Use Thread for open ADO Query in background

Title: Use Thread for open ADO Query in background Question: How Use Thread for open ADO Query in background Answer: type TOpenQuery = Class(TThread) Public constructor Create(Q: TADOQuery;sSQL: String); protected tQry: TADOQuery; tSQL: String; procedure Execute; override; end; . . . . . { TOpenQuery } constructor TOpenQuery.Create(Q: TADOQuery; sSQL: String); begin inherited Create(False); FreeOnTerminate:=True; tQry:=Q; tSQL:=sSQL; end; procedure TOpenQuery.Execute; begin inherited; Screen.Cursor:=crAppStart; with tQry do Begin SQL.Text:=tSQL; Open; End; Screen.Cursor:=crDefault; end;