untdberr.pas

自己做的一个例子

unit UntDBErr;

interface

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

type
  TFrm_DBErr = class(TForm)
    Qry_R: TADOQuery;
    txt_sID: TEdit;
    Label1: TLabel;
    BitBtn1: TBitBtn;
    procedure BitBtn1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Frm_DBErr: TFrm_DBErr;

implementation
Uses Unit1;

{$R *.dfm}

procedure TFrm_DBErr.BitBtn1Click(Sender: TObject);
begin
    With Qry_R do
    Try
        Close;
        SQL.Text:='Insert Into Fittings (sID) ';
        SQL.Add('Values(:sID) ');
        Parameters.ParamValues['sID']:=txt_sID.Text;
        ExecSQL;
    Except
        On E:Exception do Begin
            //(E as EOleException)
            ShowMessage( '错误：'+#13+SQL.Text+#13+E.ClassName+#13+E.Message);
        End;
    End;
end;

procedure TFrm_DBErr.FormCreate(Sender: TObject);
begin
    txt_sID.Text:='0000000001';
end;

end.