quote:

---

Originally posted by HuwR

it is cachesize which governs how many records are fetched, not the pagesize, if you set cachesize to 15 and pagesize, it will only fetch 15 records, not the whole 25.

---

quote:

---

MyODBC 3.51 supports three types of scrollable cursors, using this, an application can move backward and forward in the result set based on the requirement:

Forward-only
Static and
Dynamic (only from MyODBC 3.51.01)
Note, driver doesn't yet support Key set-Driven Cursor type, and to have dynamic support, one must check the option "Enable Dynamic Cursor Type" from DSN settings or by passing OPTION=32 as the connection string.


Application can set the cursor type through SQLSetStmtAttr (or SQLSetStmtOption in MyODBC 2.50 driver) with option as SQL_ATTR_CURSOR_TYPE. By default, driver implicitly uses forwards-only cursor.


Using the forwards-only cursor, an application can only forward in the result set, and it can not go backward, where as in the other case, Static cursor type, an application can move forward or backward or to any desired location in the result set.

---

Recordset.PageSize = varNumberOfRecords
varPageCount = Recordset.PageCount
if varPageNumber > varPageCount then varPageNumber = varPageCount
Recordset.AbsolutePage = varPageNumber
varRowsArray = Recordset.GetRows(varNumberOfRecords, adBookmarkCurrent)

'adBookmarkCurrent = 0 
'This is also default setting for GetRows 
'the following statement will behave same as above
 
varRowsArray = Recordset.GetRows(varNumberOfRecords)