query.~pas

Delphi6分布式开发例程9 )

unit query;

interface

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

type
  TForm1 = class(TForm)
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    Panel1: TPanel;
    Database1: TDatabase;
    DataSource1: TDataSource;
    Query1: TQuery;
    Button1: TButton;
    Edit1: TEdit;
    ComboBox1: TComboBox;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure ComboBox1Select(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
        query1.Active:=false;
//send the SQL statement
        Query1.SQL.Clear;
        while edit1.Text='' do
        begin
                showmessage('select the tablename first');
                edit1.Text:='select * from animals';//set it as default
        end;
        query1.SQL.Add(edit1.Text);
        query1.Active:=true;
end;

procedure TForm1.FormCreate(Sender: TObject);
begin
        Database1.GetTableNames(Combobox1.Items, False);
end;

procedure TForm1.ComboBox1Select(Sender: TObject);
begin
        edit1.Text:='select * from '+combobox1.Text;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
        edit1.Text:='';
end;

end.