|
Hi Jeff,
Regarding the SQLFetchScroll, according to the manual, the offset parameter can be the number rows to fetch.SQLINTEGER FetchOffset input Number of the row to fetch. The interpretation of this argument depends on the value of the FetchOrientation argument.
This says "Number of the row to fetch". This means that it will fetch ONE row (note that it says "row", not "rows") and the row that it fetches will be identified by the number you specify.
midrange.com
For example:
SQLFetchScroll( stmt: SQL_FETCH_RELATIVE: 15);
This means that it'll move the cursor forward 15 rows, and then fetch the
row at that position.
The third parameter (called "offset") is ignored for SQL_FETCH_NEXT, SQL_FETCH_PRIOR, SQL_FETCH_FIRST and SQL_FETCH_LAST -- as I said earlier, it's only used with SQL_FETCH_RELATIVE (on other systems, there's also SQL_FETCH_ABSOLUTE, though this isn't listed in the iSeries docs.)
I assume that the SQLGetDiagRec is failing for the same reason as the other statement?If so, what should I use to get the reason for an error?
I'm not familiar with SQLGetDiagRec, I always use SQLError
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
