ustat.~pas

delphi数据库的程序代码

unit Ustat;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Grids, DBGrids, DBCtrls;

type
  TForm5 = class(TForm)
    Label1: TLabel;
    DBGrid1: TDBGrid;
    Button1: TButton;
    procedure RadioButton1Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form5: TForm5;

implementation

uses Udm;

{$R *.dfm}

procedure TForm5.RadioButton1Click(Sender: TObject);
begin
  DBLookupComboBox1.Enabled := RadioButton1.Checked;
  strSql :='Select ISBN '
          +'From SalesList '
          +'Group by ISBN Order By SUM(Amount)';
          +'Having
  if Dm.QueryStat.Active then
    Dm.QueryStat.Active :=False;
  Dm.QueryStat.Active :=True;
end;

procedure TForm5.Button1Click(Sender: TObject);
begin
  Close;
end;

end.