csetquery.txt

一个程序而已

CSetQuery代码清单

unit SetQuery;
interface
uses
  Windows, Messages, Classes, SysUtils, Graphics, Controls, StdCtrls, Forms,
  Dialogs, DBCtrls, DB, DBGrids, DBTables, Grids, ExtCtrls;
type
  TfrmSetQuery = class(TForm)
    LastNameQueryCustNum: TIntegerField;
    LastNameQueryLastName: TStringField;
    LastNameQueryFirstName: TStringField;
    LastNameQueryStreet: TStringField;
    LastNameQueryCity: TStringField;
    LastNameQueryState: TStringField;
    LastNameQueryAreaCode: TStringField;
    LastNameQueryPhone: TStringField;
    LastNameQueryZipCode: TStringField;
    LastNameQueryClientType: TStringField;
    LastNameQuerySalesPersonNum: TFloatField;
    DBGrid1: TDBGrid;
    DBNavigator: TDBNavigator;
    Panel1: TPanel;
    DataSource1: TDataSource;
    Panel2: TPanel;
    LastNameQuery: TQuery;
    cmdExit: TButton;
    cmdSetQuery: TButton;
    procedure FormCreate(Sender: TObject);
    procedure cmdExitClick(Sender: TObject);
    procedure cmdSetQueryClick(Sender: TObject);
  private
    { private declarations }
  public
    { public declarations }
  end;
var
  frmSetQuery: TfrmSetQuery;
implementation
{$R *.DFM}
procedure TfrmSetQuery.FormCreate(Sender: TObject);
begin
  LastNameQuery.Open;
end;
procedure TfrmSetQuery.cmdExitClick(Sender: TObject);
begin
Application.Terminate;
end;
procedure TfrmSetQuery.cmdSetQueryClick(Sender: TObject);
var
LastNameString:String;
begin
LastNameString:=
InputBox('Set the LastName field',
         'Enter Last Name:',
         '');
LastNameQuery.DisableControls;
try
    LastNameQuery.Active:=False;
    LastNameQuery.Params[0].AsString:=
               LastNameString;
    LastNameQuery.Active:=True;
finally
    LastNameQuery.EnableControls;
end;
end;
end.