Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ishwarbg
Starting Member
4 Posts |
 Posted - 2007-11-13 : 08:00:34
|
| Hi friends,I am facing problem with SQLRowCount() function which is returning -1 when I tried to fetch records greater than 99 from my data file. if the data file contains total of 99 records then the above function is returning its second parameter value nRowCount as 99 but if dat file contains 100 records then it is returning nRowCount as -1Please tell me whether it is a driver specic error or some thing else. I am using a ODBC driver for a database called MYOB.Below is the piece of code that I used for fetching records.if (SQLExecDirect(m_StmtHandle, (PUCHAR)sExecuteStatement.c_str(), SQL_NTS) != SQL_SUCCESS) return false; if (SQLNumResultCols(m_StmtHandle,(SQLSMALLINT *) &nColumnCount) != SQL_SUCCESS) return false;if (SQLRowCount(m_StmtHandle,&nRowCount) != SQL_SUCCESS) return false; The string 'sExecuteStatement' in SQLExecDirect() function above is carrying a Select query that fetch 100 records.Its strange that the function fails to return exact row count for 100 records, but it is working fine with 99 records.I ma not using any kind of array with size of 99 or 100 in my code.What I want to know is whether I can use SQLRowCount() with SELECT statement, If not what is the alternative.Pleasee help me with a piece of code if you can.Ishwar B.G |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
|
|
|
|
|
SQLRowCount() returning -1 for SELECT statement