您所在位置：主题：TQuery+TDataSource+TDBGrid
xuyuansheng
[专家分：0] 发布于 2009-03-17 10:11:00
Hello all,
我用TQuery+TDataSource+TDBGrid组合来操作数据库，部份代码如下：
Query1->DatabaseName = "XXX";
if (Query1->Active)
Query1->Close();
Query1->SQL->Clear();
Query1->SQL->AddStrings(this->Memo_SQL->Lines); //"SELECT Name, ID, Description FROM Project"
Query1->Open();
int nCount = Query1->RecordCount;
strMsg = IntToStr(nCount) + " rows";
Query1->First() ;
while (!Query1->Eof)
{
strMsg += Query1->FieldByName("ID")->AsString;
Query1->Next();
}
Query1->Close();
Edit_Msg->Text = strMsg;
会提示：Query1:Field 'ID' not found.
请问是什么原因呢？以上SQL语句在数据库中正常执行。
我用TQuery+TDataSource+TDBGrid组合来操作数据库，部份代码如下：
Query1->DatabaseName = "XXX";
if (Query1->Active)
Query1->Close();
Query1->SQL->Clear();
Query1->SQL->AddStrings(this->Memo_SQL->Lines); //"SELECT Name, ID, Description FROM Project"
Query1->Open();
int nCount = Query1->RecordCount;
strMsg = IntToStr(nCount) + " rows";
Query1->First() ;
while (!Query1->Eof)
{
strMsg += Query1->FieldByName("ID")->AsString;
Query1->Next();
}
Query1->Close();
Edit_Msg->Text = strMsg;
会提示：Query1:Field 'ID' not found.
请问是什么原因呢？以上SQL语句在数据库中正常执行。
