the rno should be 3. but it is zero always. the active, sel, valid are all false, while result is true.Qt Code:
bool result = query.exec("SELECT Rno FROM tbl_phone WHERE Tel=\'158123456\'"); bool active = query.isActive(); bool sel = query.isSelect(); bool valid = query.isValid(); int rno = query.value(0).toInt();To copy to clipboard, switch view to plain text mode
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.
Bookmarks