ODBC Using SQLExtendedFetch

Go back to: Code Samples
rc = SQLSetStmtOption(hstmt, SQL_ROWSET_SIZE, 100); 
 
/* Use arrays of 100 elements */
rc = SQLExecDirect(hstmt, "SELECT <20 columns> FROM employees " +
                   "WHERE HireDate >= ?", SQL_NTS);
 
/* Call SQLBindCol one time specifying row-wise binding */
do {
rc = SQLExtendedFetch(hstmt, SQL_FETCH_NEXT, 0,
     &RowsFetched, RowStatus);
} while ((rc == SQL_SUCCESS) || (rc == SQL_SUCCESS_WITH_INFO));




Like what you see? Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • LinkedIn
  • Reddit
  • StumbleUpon
  • Technorati
  • TwitThis

Book Content Copyright © 2009 by Prentice Hall PTR. All rights reserved. | Corporate Sponsor DataDirect Technologies.