1,178
社区成员
发帖
与我相关
我的任务
分享
ADOQuery2->DisableControls();
...... //数据库操作
......
......
ADOQuery2->EnableControls();
...... //界面操作
......
int a,b;
sqlCmd="SELECT sum(zj) FROM room_1;";
ADOQuery2->SQL->Clear(); // 必须先Clear再Add最后Open,顺序不能改
ADOQuery2->SQL->Add(sqlCmd);
ADOQuery2->Open(); //只能查
//ADOQuery2->EnableControls();
a=DBGrid1->Columns->Grid->Fields[0]->Value;
//a=DBGrid1->`FieldByName("total_title")->AsString;
//ADOQuery2->DisableControls();
sqlCmd="SELECT sum(zj) FROM room_2;";
ADOQuery2->SQL->Clear();
ADOQuery2->SQL->Add(sqlCmd);
ADOQuery2->Open(); //只能查
//ADOQuery2->EnableControls();
b=DBGrid1->Columns->Grid->Fields[0]->Value;
total=a+b;
ShowMessage( "\t房租统计信息\n\n"
"\t1楼: "+IntToStr(a)+"元\t\t\n"+
"\t2楼: "+IntToStr(b)+"元\n"+
"\t合计: "+IntToStr(total)+"元\n" );
是不是我的操作不正确??