fmddemoclientmain.pas

来自「就是这本书的随书代码。包括《实战Delphi 5.x-分布式多层应用系统篇》」· PAS 代码 · 共 72 行

unit fMDDemoClientMain;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Db, Grids, DBGrids, ExtCtrls, DBCtrls, DBClient, MConnect, SConnect,
  StdCtrls;

type
  TForm2 = class(TForm)
    DataSource1: TDataSource;
    ClientDataSet1: TClientDataSet;
    SocketConnection1: TSocketConnection;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    DBNavigator2: TDBNavigator;
    DataSource2: TDataSource;
    ClientDataSet1pub_name: TStringField;
    ClientDataSet1city: TStringField;
    ClientDataSet1state: TStringField;
    ClientDataSet1country: TStringField;
    ClientDataSet1adsDetail: TDataSetField;
    ClientDataSet2: TClientDataSet;
    ClientDataSet2title: TStringField;
    ClientDataSet2type: TStringField;
    ClientDataSet2price: TBCDField;
    ClientDataSet2advance: TBCDField;
    ClientDataSet2royalty: TIntegerField;
    ClientDataSet2ytd_sales: TIntegerField;
    ClientDataSet2notes: TStringField;
    ClientDataSet2pubdate: TDateTimeField;
    cdsGeneral: TClientDataSet;
    Panel1: TPanel;
    DBNavigator1: TDBNavigator;
    btnApplyUpdates: TButton;
    procedure FormActivate(Sender: TObject);
    procedure btnApplyUpdatesClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form2: TForm2;

implementation

{$R *.DFM}

procedure TForm2.FormActivate(Sender: TObject);
var
  iCount : Integer;
begin
  cdsGeneral.Close;
  cdsGeneral.CommandText := 'select distinct type from titles';
  cdsGeneral.Open;
  for iCount := 0 to cdsGeneral.RecordCount - 1 do
  begin
    DBGrid2.Columns.Items[1].PickList.Add(cdsGeneral.Fields[0].Value);
    cdsGeneral.Next;
  end;
end;

procedure TForm2.btnApplyUpdatesClick(Sender: TObject);
begin
  ClientDataSet1.ApplyUpdates(0);
end;

end.