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)
{
  Table1->Edit();
  Table1->FieldByName("科目代码")->AsString=Edit1->Text.Trim();
  Table1->FieldByName("科目名称")->AsString=Edit2->Text.Trim();
  Table1->Post();
}
//---------------------------------------------------------------------------
void __fastcall TForm1::Button2Click(TObject *Sender)
{
  AnsiString filename,oldkmno,kmno,kmname;
  filename="test.dbf";
  oldkmno=Table1->FieldByName("科目代码")->AsString;
  kmno=Edit1->Text.Trim();
  kmname=Edit2->Text.Trim();
  Query1->Active=False;
  Query1->SQL->Clear();
  Query1->SQL->Add("UPDATE \""+filename+"\"");
  Query1->SQL->Add("SET  科目代码='"+kmno+"',科目名称='"+kmname+"'");
  Query1->SQL->Add("WHERE  科目代码='"+oldkmno+"'");
//  Query1->Prepare();//不能用此，产生错误信息“Table read now”
  Query1->ExecSQL();
  if(Query1->RowsAffected==1)
    ShowMessage("记录修改成功!");
}
//---------------------------------------------------------------------------