运行后显示列名shelcount无效是为什么啊？
ADOQuery2->SQL->Text="Select gnum,shelnum,gname,gcount,shelcount from dbo.goods where shelnum= '" + Edit1->Text + "'";
ADOQuery2->ExecSQL();
ADOQuery2->Active=true;
String strSQL1="";
strSQL1="Update dbo.shelf set shelcount = shelcount + " + Edit2->Text + " where shelnum = " + Edit1->Text;
ADOQuery2->SQL->Text=strSQL1;
ADOQuery2->ExecSQL();
ADOQuery2->SQL->Text="Select gnum,shelnum,gname,gcount,shelcount from dbo.goods where shelnum= '" + Edit1->Text + "'";
ADOQuery2->Active=true;

[解决办法]

引用:

会不会是语法错误呢？

shelf表里就没有shelcount字段，怎么修改啊？