unitsinglegoods.pas

来自「包含众多详细的delphi对数据库的访问代码」· PAS 代码 · 共 65 行

unit UnitSingleGoods;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Buttons, Db, DBTables, Mask, DBCtrls;

type
  TFormSingleGoods = class(TForm)
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    Query1: TQuery;
    DataSource1: TDataSource;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    Label4: TLabel;
    Label5: TLabel;
    procedure BitBtn1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Query1NewRecord(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

//var
//  FormSingleGoods: TFormSingleGoods;

implementation

{$R *.DFM}

procedure TFormSingleGoods.BitBtn1Click(Sender: TObject);
begin
  if Query1.State in dsEditModes then//如果在编辑状态。
    Query1.Post;                     //先Post。
  if Query1.UpdatesPending then      //如果有缓存更新的数据。
    Query1.ApplyUpdates;             //真正更新。
end;

procedure TFormSingleGoods.FormCreate(Sender: TObject);
begin
  Query1.Close;
  Query1.RequestLive:=True;
  //使用Query的返回集可以修改。
  Query1.CachedUpdates:=True;
  //使用缓存更新。也就是说Post过和并不保存数据到数据表中。而是必需要ApplyUpdates才真正保存数据。
  Query1.Open;
end;

procedure TFormSingleGoods.Query1NewRecord(DataSet: TDataSet);
begin
  Query1.FieldByName('fPrice').AsCurrency:=1;
end;

end.