unit1.pas

contains synchronous routines to open queries with possibility to cancel execution,is intended for D

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Db, OracleData, Oracle, Grids, DBGrids, Buttons, StdCtrls,
  OracleCancellableUtils, ExtCtrls;

type
  TForm1 = class(TForm)
    OracleLogon: TOracleLogon;
    OracleDataSet1: TOracleDataSet;
    DataSource1: TDataSource;
    OracleSession1: TOracleSession;
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    Panel2: TPanel;
    LogonBtn: TSpeedButton;
    ExecBtn: TSpeedButton;
    Label1: TLabel;
    Panel3: TPanel;
    Memo1: TMemo;
    procedure LogonBtnClick(Sender: TObject);
    procedure ExecBtnClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

procedure TForm1.LogonBtnClick(Sender: TObject);
begin
  if LogonBtn.Down then
    OracleLogon.Execute
  else
    OracleSession1.Logoff;
  LogonBtn.Down := OracleSession1.Connected;
  ExecBtn.Enabled := OracleSession1.Connected;
end;

procedure TForm1.ExecBtnClick(Sender: TObject);
begin
  OracleDataSet1.SQL.Text := Memo1.Lines.Text;
  OracleDataSet1.Close;
  if OpenCancellableQuery(OracleDataSet1) then
    Label1.Caption := 'Query opened'
  else
    Label1.Caption := 'Query was canceled';
end;

end.