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)
- {
- 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("记录修改成功!");
- }
- //---------------------------------------------------------------------------