From: <o_v...@vo...> - 2010-01-14 15:30:12
|
Hi, when use SQLSetStmtAttr(hstmt,SQL_ATTR_ROWS_FETCHED_PTR,&NumRowsFetched,0) to get number of fetched rows after SQLFetch(hstmt) or SQLFetchScroll(hstmt,SQL_FETCH_NEXT,0) command variable (NumRowsFetched) is never changed his value,even so data is properly readed in buffer. i test my code also against MSSQL expres and works as i expect, so i think my code is ok ( i hope:) ) i try SQLExtendedFetch which use function arguments instead of statememt attribute, and works ok, but for ODBC 3.x apllication it is not recomended use this function, and is repleaced by SQLFetchScroll, also use SQLExtendedFetch against MSSQL results to fetching only one row per call(but SQLFetchScroll works well) Notes: i have set ODBC 3 version both in "(windows)ODBC manager" and also on odbc enviroment handle. Firebird is version 2.1.3.18185 Firebird_ODBC 2.0.0.148 and 2.0.0.149 (the same result) |