Qt Code:
  1. QSqlQuery query = QSqlQuery(db);
  2.  
  3. bool result = query.exec("SELECT Rno FROM tbl_phone WHERE Tel=\'158123456\'");
  4.  
  5. bool active = query.isActive();
  6. bool sel = query.isSelect();
  7. bool valid = query.isValid();
  8.  
  9. int rno = query.value(0).toInt();
To copy to clipboard, switch view to plain text mode 
the rno should be 3. but it is zero always. the active, sel, valid are all false, while result is true.

when debugging, i find an error in QSqlResult:
" [Microsoft][ODBC SQL Server Driver][SQL Server]对象名 'tbl_phone' 无效。 [Microsoft][ODBC SQL Server Driver][SQL Server]该游标未声明。"

[Microsoft][ODBC SQL Server Driver][SQL Server] invalid object name of "tbl_phone", .... this occur is not decleared.

thx.