Fetch All (Results Menu)

The Fetch All function tool fetches all remaining rows in all pending result sets on the current StatementHandle. If any columns were bound, after Fetch All has completed these will contain the values from the last row of the last result set. The Fetch All function tool performs the following actions:

1. Calls SQLGetFunctions to determine if the driver supports SQLMoreResults.
   
   
2. Calls SQLFetch until it returns SQL_NO_DATA.
   
   
3. If the driver supports it, calls SQLMoreResults. If SQLMoreResults returns SQL_SUCCESS or SQL_SUCCESS_WITH_INFO, the Fetch All function tool returns to step 2. Otherwise, it stops.