DataBlade API Programmer's Manual Chapter 12: DataBlade API Function Descriptions

Home

Contents

Index

Master Index

New Book

mi_integer mi_fetch_statement(stmtPtr, orient, jump, count)

		MI_STATEMENT *stmtPtr;

		MI_CURSOR_ACTION orient;

		mi_integer jump;

		mi_integer count; 


stmtPtr
is a pointer to a previously opened statement

orient
determines the orientation of the fetch. Possible values for orient follow:


MI_CURSOR_NEXT
fetch the next count rows


MI_CURSOR_PRIOR
fetch the previous count rows


MI_CURSOR_FIRST
fetch the first count rows


MI_CURSOR_LAST
fetch the last count rows


MI_CURSOR_ABSOLUTE
move jump rows into the result set and fetch count rows


MI_CURSOR_RELATIVE
move jump rows from the current position and fetch count rows

jump
is the relative or absolute offset of the fetch.

count
is the number of rows to return, 0 if all rows are fetched.





 



Valid in Client Application?

Valid in Server Routine?

Yes
Yes