ADOQuery1->Open();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("Update info set count = count -'"+Edit1->Text+"' where id = '"+DBText1->Caption+"'");
ADOQuery1->ExecSQL();
...全文
422打赏收藏
关于一个异常的错误
请问下各位,这句话怎么运行的时候会报Update语句语法错误呢?实在不理解,请大家指点下,谢谢! ADOQuery1->Open(); ADOQuery1->SQL->Clear(); ADOQuery1->SQL->Add("Update info set count = count -'"+Edit1->Text+"' where id = '"+DBText1->Caption+"'"); ADOQuery1->ExecSQL();
ADOQuery1->Open();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("Update info set [count] = [count] - "+Edit1->Text+" where [id] = '"+DBText1->Caption+"'");
ADOQuery1->ExecSQL();