创建了两个表T1,T2,从T1表中遍历每一条记录,提取每条记录的一字段的值,将其赋给QString变量myName,再在T2中查询某字段包含该变量的记录,但是查询的时候却出现 not positioned on a valid record的问题,请问下是那里有错误啊?
void myScene::drawItem(const QString dbFilename)
{
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(dbFilename);
if (!db.open())
{
qDebug()<<"wrong";
}
QSqlQuery query ;
query.exec("select ID, XPOS, YPOS, NAME from T1 ");
while(query.next())
{
......
QString myName = query.value(3).toString();
checkT2(myName);
......
}
}
void myScene::checkT2(const QString Name)
{
QSqlQuery query1;
query1.exec("select * from T2 where A2='"+ Name +"'");
QString myPos = query1.value(1).toString();
qDebug()<<myPos ;
}