yd_undo.~pas

结于初学者来说这对数据库是一个很好的例子

unit YD_Undo;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, DBTables;

type
  TForm12 = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Button1: TButton;
    Button2: TButton;
    Edit1: TEdit;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Q_undo: TQuery;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form12: TForm12;

implementation

uses RoomInInfo, main;

{$R *.dfm}

procedure TForm12.Button2Click(Sender: TObject);
begin
  close;
end;

procedure TForm12.Button1Click(Sender: TObject);
  var RoomName:string;
begin
  RoomName:=edit1.Text;
  Q_undo.SQL.Clear;
  Q_undo.SQL.Add('update RoomInfo set RoomStatus=0 where RoomName='''+RoomName+'''');
  Q_undo.ExecSQL;
  Q_undo.SQL.Clear;
  Q_undo.SQL.Add('delete from RoomIn where RoomName='''+RoomName+'''');
  Q_undo.ExecSQL;
//  form10.Q_room.active:=false;
//  form10.Q_room.active:=True;
//  form1.refe;
  Form12.Close;
end;

end.