运行后提示 String strSQL1=""附近有异常

2013-01-04

运行后提示 String strSQL1附近有错误 ADOQuery2-SQL-TextSelect * from dbo.warehouse where war

运行后提示 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();