数据库添加数据？
数据库有一表：字段1 字段2 字段3
AA BB CC
一开始字段1 字段2 有数据 比如 12 34 字段CC 没有
现在有数据56 想放到CC字段里 形成
AA BB CC
12 34 56
c++builder AQOQuery 怎么写代码呀 谢谢老师！

[解决办法]
adoquery->Close();
adoquery->SQL->Text="update table(AA,BB,CC) set CC=56 where AA=12 and BB=34";
adoquery->ExecSQL();

看看书
[解决办法]

C/C++ code

ADOQuery1->SQL->Text = String().sprintf(    "Update 测量结果 Set 修正值=% where 未修正值=%s",    LabelYXZDZL->Caption, LabelWXZDZL->Caption);ADOQuery1->ExecSQL();
[解决办法]
供参考
C/C++ code
SqlStr="Select Top 1 * from  ";        SqlStr+=VehTableName;        DataMod->InsertQuery->Close();        DataMod->InsertQuery->SQL->Clear();        DataMod->InsertQuery->SQL->Add(SqlStr);        DataMod->InsertQuery->ExecSQL();        DataMod->InsertQuery->Open();        DataMod->InsertQuery->Append();        PrintTime=Now();        DataMod->InsertQuery->FieldByName("VEH_DATETIME")->AsDateTime=PrintTime;        DataMod->InsertQuery->FieldByName("VEH_AXLENUM")->AsInteger=Vehicle.AxleNum;        DataMod->InsertQuery->FieldByName("veh_AXLEGrNUM")->AsInteger=Vehicle.AxleGrNum;        DataMod->InsertQuery->FieldByName("VEH_WEIGHT")->AsInteger=Vehicle.Weight;        DataMod->InsertQuery->FieldByName("OVERLOAD")->AsInteger=Vehicle.OverLoad;        DataMod->InsertQuery->FieldByName("Limit")->AsInteger=Vehicle.Limit;        if(Vehicle.Limit)        DataMod->InsertQuery->FieldByName("OVERPER")->AsInteger=Vehicle.OverLoad*100/Vehicle.Limit;        DataMod->InsertQuery->FieldByName("VEH_SPEED")->AsInteger=Vehicle.Speed;    DataMod->InsertQuery->Post();