change1.~pas

来自「有关delphi的应用」· ~PAS 代码 · 共 68 行

unit change1;

interface

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

type
  Tfrmchange1 = class(TForm)
    Label1: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmchange1: Tfrmchange1;

implementation

uses datalink, dinsert;

{$R *.dfm}

procedure Tfrmchange1.Button1Click(Sender: TObject);
var str:string;
begin

  str:='update device_testvalue1 set testvalue='''+edit1.text+''' where (value_id1='''+inttostr(frminsert.DBGrid1.Fields[0].Value)+''')';
  with dm do
  begin
    with adoquery1 do
    begin
      close;
      with sql do
      begin
        clear;
        add(str);
      end;
      execsql;
    end;
  end;
  frminsert.ADODataSet1.Active:=false;
  frminsert.ADODataSet1.Active:=true;

  frmchange1.Close;
end;

procedure Tfrmchange1.Button2Click(Sender: TObject);
begin
 frmchange1.Close;
end;

procedure Tfrmchange1.FormShow(Sender: TObject);
begin
    edit1.Text:=frminsert.DBGrid1.Fields[2].Value;
end;

end.