dbcursorfetch supports a variety of fetch types. Table 6-3 lists dbcursorfetch fetch types and their Client-Library equivalents, if any:
dbcursor fetch type |
Client-Library equivalent |
---|---|
FETCH_FORWARD |
ct_fetch or ct_scroll_fetch with fetch orientation (or type) set as CS_NEXT |
FETCH_FIRST |
ct_scroll_fetch with fetch orientation (or type) set as CS_FIRST |
FETCH_PREVIOUS |
ct_scroll_fetch with fetch orientation (or type) set as CS_PREV |
FETCH_RANDOM |
ct_scroll_fetch with fetch orientation (or type) set as CS_ABSOLUTE |
FETCH_RELATIVE |
ct_scroll_fetch with fetch orientation (or type) set as CS_RELATIVE |
FETCH_LAST |
ct_scroll_fetch with fetch orientation (or type) set as CS_LAST |