Connector/ODBC 5 commit: r628 - in trunk/Driver: Driver/Library examples/c

[pharvey]

Modified:
   trunk/Driver/Driver/Library/SQLFetch.cpp
   trunk/Driver/Driver/Library/SQLGetData.cpp
   trunk/Driver/Driver/Library/SQLGetDiagFieldW.cpp
   trunk/Driver/Driver/Library/SQLGetInfoW.cpp
   trunk/Driver/Driver/Library/SQLNumResultCols.cpp
   trunk/Driver/Driver/Library/SQLSetStmtAttrW.cpp
   trunk/Driver/examples/c/tutorial_09.c
Log:
ENH: Doc


Modified: trunk/Driver/Driver/Library/SQLFetch.cpp
===================================================================
--- trunk/Driver/Driver/Library/SQLFetch.cpp	2006-10-23 18:51:11 UTC (rev 627)
+++ trunk/Driver/Driver/Library/SQLFetch.cpp	2006-10-23 20:49:32 UTC (rev 628)
@@ -44,7 +44,7 @@
     \retval SQL_NO_DATA             No data affected.
     \retval SQL_INVALID_HANDLE      Invalid handle was provided.
 
-    \include    tutorial_09.c
+    \include    tutorial_10.c
 */
 SQLRETURN SQL_API SQLFetch( SQLHSTMT hStm )
 {

Modified: trunk/Driver/Driver/Library/SQLGetData.cpp
===================================================================
--- trunk/Driver/Driver/Library/SQLGetData.cpp	2006-10-23 18:51:11 UTC (rev 627)
+++ trunk/Driver/Driver/Library/SQLGetData.cpp	2006-10-23 20:49:32 UTC (rev 628)
@@ -86,7 +86,7 @@
             SQLExtendedFetch 
             SQLFetchScroll
 
-    \include    tutorial_09.c
+    \include    tutorial_10.c
 */
 SQLRETURN SQL_API SQLGetData( SQLHSTMT     hStm,
                               SQLUSMALLINT nColumnNumber,

Modified: trunk/Driver/Driver/Library/SQLGetDiagFieldW.cpp
===================================================================
--- trunk/Driver/Driver/Library/SQLGetDiagFieldW.cpp	2006-10-23 18:51:11 UTC (rev 627)
+++ trunk/Driver/Driver/Library/SQLGetDiagFieldW.cpp	2006-10-23 20:49:32 UTC (rev 628)
@@ -29,6 +29,9 @@
 */
 #include "MYODBCDriverInternal.h"
 
+/*!
+    \include    tutorial_09.c
+*/
 SQLRETURN SQL_API SQLGetDiagFieldW( SQLSMALLINT      nHandleType,
                                     SQLHANDLE        hHandle,
                                     SQLSMALLINT      nRecNumber,

Modified: trunk/Driver/Driver/Library/SQLGetInfoW.cpp
===================================================================
--- trunk/Driver/Driver/Library/SQLGetInfoW.cpp	2006-10-23 18:51:11 UTC (rev 627)
+++ trunk/Driver/Driver/Library/SQLGetInfoW.cpp	2006-10-23 20:49:32 UTC (rev 628)
@@ -58,6 +58,8 @@
     \retval SQL_SUCCESS_WITH_INFO   Request was probably processed ok - check diagnostic.
     \retval SQL_ERROR               Request failed.
     \retval SQL_INVALID_HANDLE      Invalid handle was provided.
+
+    \include    tutorial_10.c
 */
 SQLRETURN SQL_API SQLGetInfoW( SQLHDBC       hDbc, 
                                SQLUSMALLINT  nInfoType,

Modified: trunk/Driver/Driver/Library/SQLNumResultCols.cpp
===================================================================
--- trunk/Driver/Driver/Library/SQLNumResultCols.cpp	2006-10-23 18:51:11 UTC (rev 627)
+++ trunk/Driver/Driver/Library/SQLNumResultCols.cpp	2006-10-23 20:49:32 UTC (rev 628)
@@ -45,6 +45,8 @@
     \retval SQL_STILL_EXECUTING     Still executing from a previous call.     
     \retval SQL_ERROR               Request failed.
     \retval SQL_INVALID_HANDLE      Invalid handle was provided.
+
+    \include    tutorial_07.c
 */
 SQLRETURN SQL_API SQLNumResultCols( SQLHSTMT        hStm, 
                                     SQLSMALLINT *   pnColumnCountPtr )

Modified: trunk/Driver/Driver/Library/SQLSetStmtAttrW.cpp
===================================================================
--- trunk/Driver/Driver/Library/SQLSetStmtAttrW.cpp	2006-10-23 18:51:11 UTC (rev 627)
+++ trunk/Driver/Driver/Library/SQLSetStmtAttrW.cpp	2006-10-23 20:49:32 UTC (rev 628)
@@ -29,6 +29,9 @@
 */
 #include "MYODBCDriverInternal.h"
 
+/*!
+    \include    tutorial_09.c
+*/
 SQLRETURN SQL_API SQLSetStmtAttrW( SQLHSTMT      hStm, 
                                    SQLINTEGER    nAttribute, 
                                    SQLPOINTER    pValue, 

Modified: trunk/Driver/examples/c/tutorial_09.c
===================================================================
--- trunk/Driver/examples/c/tutorial_09.c	2006-10-23 18:51:11 UTC (rev 627)
+++ trunk/Driver/examples/c/tutorial_09.c	2006-10-23 20:49:32 UTC (rev 628)
@@ -24,8 +24,14 @@
     nReturn = SQLSetEnvAttr( hEnv, SQL_ATTR_ODBC_VERSION, SQL_OV_ODBC3, 0 );
     nReturn = SQLAllocHandle( SQL_HANDLE_DBC, hEnv, &hDbc );
     nReturn = SQLConnect( hDbc, pszDSN, SQL_NTS, pszUID, SQL_NTS, pszPWD, SQL_NTS );
+    nReturn = SQLAllocHandle( SQL_HANDLE_STMT, hDbc, hStmt );
+
+    /* We want a forward-only cursor (most common). */
+    nReturn = SQLSetStmtAttr( hStm, SQL_ATTR_CURSOR_TYPE,
(SQLPOINTER)SQL_CURSOR_FORWARD_ONLY, 0 );
+
+    /* Get some driver capabilities for a forward-only cursor. */
     nReturn = SQLGetInfo( hDbc, SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2,
&nForwardOnlyCursorAttributes2, SQL_IS_UINTEGER, 0 );  
-    nReturn = SQLAllocHandle( SQL_HANDLE_STMT, hDbc, hStmt );
+
     nReturn = SQLExecDirect( hStmt, pszSQL, pszCommand, SQL_NTS );
     if ( !SQL_SUCCEEDED( nReturn ) )
         goto exit1;
@@ -40,10 +46,10 @@
 
     if ( nResultSetRows < 0 )
         printf( "Could not determine ResultSetRows.\n" );
+    else if ( nForwardOnlyCursorAttributes2 & SQL_CA2_CRC_APPROXIMATE )
+        printf( "ResultSetRows is %ld and is an approximate value.\n", nResultSetRows );
     else if ( nForwardOnlyCursorAttributes2 & SQL_CA2_CRC_EXACT )
         printf( "ResultSetRows is %ld and is an exact value.\n", nResultSetRows );
-    else if ( nForwardOnlyCursorAttributes2 & SQL_CA2_CRC_APPROXIMATE )
-        printf( "ResultSetRows is %ld and is an approximate value.\n", nResultSetRows );
     else
         printf( "ResultSetRows is %ld and may or may not be accurate.\n", nResultSetRows
);