 |
SQLFetch
..msdn Add comment W32 Constants Translate this page |
|
|
|
SQLFetch fetches the next rowset of data from the result set and returns data for all bound columns. |
|
|
| Code examples: |
|
|
|
|
|
| Declaration: |
|
|
SQLRETURN SQLFetch(
SQLHSTMT StatementHandle);
|
|
|
|
| FoxPro declaration: |
|
|
DECLARE SHORT SQLFetch IN odbc32;
INTEGER StatementHandle
|
|
|
|
| Parameters: |
|
StatementHandle
[Input]
Statement handle. |
|
|
| Return value: |
|
| SQL_SUCCESS (0), SQL_SUCCESS_WITH_INFO, SQL_NO_DATA, SQL_STILL_EXECUTING, SQL_ERROR (-1), or SQL_INVALID_HANDLE (-2). |
|
|
| My comment: |
|
SQLFetch returns the next rowset in the result set. It can be called only while a result set existsthat is, after a call that creates a result set and before the cursor over that result set is closed. If any columns are bound, it returns the data in those columns.
When the result set is created, the cursor is positioned before the start of the result set. SQLFetch fetches the next rowset. It is equivalent to calling SQLFetchScroll with FetchOrientation set to SQL_FETCH_NEXT. |
|
|
| Word Index links for the SQLFetch : |
|
|
|
|
|
| Translate this page: |
|
|
|
|
| |
|
| Created: | 2003-05-28 09:10:49 | | Modified: | 2003-05-28 09:13:07 |
Visited in last 7 days: 16 |
