csoapy
2nd April 2010, 13:02
QSqlQuery query = QSqlQuery(db);
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();
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.
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();
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.