Unit1.cpp
上传用户:lhxd_sz
上传日期:2014-10-02
资源大小:38814k
文件大小:1k
- //---------------------------------------------------------------------------
- #include <vcl.h>
- #pragma hdrstop
- #include "Unit1.h"
- //---------------------------------------------------------------------------
- #pragma package(smart_init)
- #pragma resource "*.dfm"
- TForm1 *Form1;
- //---------------------------------------------------------------------------
- __fastcall TForm1::TForm1(TComponent* Owner)
- : TForm(Owner)
- {
- }
- //---------------------------------------------------------------------------
- void __fastcall TForm1::Button1Click(TObject *Sender)
- {
- AnsiString ass;
- ass=Table1->FieldByName("科目代码")->AsString;
- if(Application->MessageBox(("一定要删除科目代码为:"+ass+" 的记录吗?").c_str(),"提示",MB_YESNO)==IDYES)
- Table1->Delete();
- }
- //---------------------------------------------------------------------------
- void __fastcall TForm1::Button2Click(TObject *Sender)
- {
- AnsiString filename,oldkmno;
- filename="test.dbf";
- oldkmno=Table1->FieldByName("科目代码")->AsString;
- if(Application->MessageBox(("一定要删除科目代码为:"+oldkmno+" 的记录吗?").c_str(),"提示",MB_YESNO)!=IDYES)return;
- Query1->Active=False;
- Query1->SQL->Clear();
- Query1->SQL->Add("DELETE FROM ""+filename+""");
- Query1->SQL->Add("WHERE 科目代码='"+oldkmno+"'");
- Query1->ExecSQL();
- if(Query1->RowsAffected>=1)
- ShowMessage("记录删除成功!");
- }
- //---------------------------------------------------------------------------