main.pas

suite component ace report

unit Main;

interface

uses
{$ifdef win32}
  Windows,
{$else}
wintypes,winprocs,
{$endif}
   Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, ExtCtrls, Grids, DBGrids, Db, DBTables;

type
  TForm1 = class(TForm)
    SQLQuery: TQuery;
    SQLSource: TDataSource;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    SqlMemo: TMemo;
    Label1: TLabel;
    Button1: TButton;
    PrintButton: TButton;
    procedure Button1Click(Sender: TObject);
    procedure PrintButtonClick(Sender: TObject);
    procedure SqlMemoChange(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

uses DSR;

procedure TForm1.Button1Click(Sender: TObject);
begin
  SQLQuery.Close;
  SQLQuery.SQL.Assign(SQLMemo.Lines);
  SQLQuery.Open;
  PrintButton.Enabled := True;
end;

procedure TForm1.PrintButtonClick(Sender: TObject);
begin
  GenerateReport(SQLSource);
end;

procedure TForm1.SqlMemoChange(Sender: TObject);
begin
  if SQLQuery.Active then
  begin
    SQLQuery.Close;
    PrintButton.Enabled := False;
  end;
end;

end.