unit1.cpp

有视频

//---------------------------------------------------------------------------
#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("记录删除成功!");
}
//---------------------------------------------------------------------------