运行后提示 String strSQL1="";附近有错误
ADOQuery2->SQL->Text="Select * from dbo.warehouse where warenum = " + a ;
//ADOQuery2->ExecSQL();
ADOQuery2->Active=true;
String strSQL1="";
strSQL1="Update dbo.warehouse set warelespa = warelespa - " + Edit2->Text + " where warenum = " + a;
ADOQuery2->SQL->Text=strSQL1;
ADOQuery2->ExecSQL();
ADOQuery2->SQL->Text="Select * from dbo.warehouse where warenum = " + a ;
ADOQuery2->Active=true;

[解决办法]
本帖最后由 ccrun 于 2012-12-24 10:04:33 编辑

String strSQL1;
strSQL1.sprintf(
    "Update dbo.warehouse set warelespa=warelespa-%s where warenum=%d", Edit2->Text, a);

ADOQuery2->SQL->Text = strSQL1;
ADOQuery2->ExecSQL();

strSQL1.sprintf("Select * from dbo.warehouse where warenum=%d", a);
ADOQuery2->SQL->Text = strSQL1;
ADOQuery2->Open();