数据库添加数据?
数据库有一表:字段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();
看看书
[解决办法]
ADOQuery1->SQL->Text = String().sprintf( "Update 测量结果 Set 修正值=% where 未修正值=%s", LabelYXZDZL->Caption, LabelWXZDZL->Caption);ADOQuery1->ExecSQL();
[解决办法]
供参考
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();