数据库查询问题
请问各位大哥 我怎么用一个变量来接收一个统计的sql语句的查询值
[解决办法]
sql语句是什么样,返回结果是多个字段还是一个字段,一行还是多行
[解决办法]
如果是 使用ADO 可以使用如下形式:
.... //定义 _Query TADOQuery *_Query = new TADOQuery(this); _Query->ConnectionString = AnsiString( __pADO_Mem->ADOConnectStr ); _Query->CommandTimeout = 5; _Query->Close(); String strSQL; try { _Query->Close(); _Query->SQL->Clear(); //A1、A2是表A的两列 strSQL = "SELECT * FROM A WHERE A1 = '" + strA1 "'"; _Query->SQL->Add(); _Query->Open; if(_Query->RecordCount > 0) { String strA2; strA2 = _Query->FieldByName("AtomTranCode")->AsString; } } catch(...) { _Query->Close(); delete _Query; } _Query->Close(); delete _Query; .....