Connector/ODBC 5 commit: r451 - trunk/examples/CPP/7/ADO

[pharvey]

Modified:
   trunk/examples/CPP/7/ADO/main.cpp
Log:
C++ ADO example shows that int param is fine but string param does not work

Modified: trunk/examples/CPP/7/ADO/main.cpp
===================================================================
--- trunk/examples/CPP/7/ADO/main.cpp	2006-07-19 04:22:35 UTC (rev 450)
+++ trunk/examples/CPP/7/ADO/main.cpp	2006-07-19 04:42:45 UTC (rev 451)
@@ -216,20 +216,30 @@
     _CommandPtr     pCommand            = NULL;
     _ParameterPtr   pParameter          = NULL;
     _RecordsetPtr   pRecordset          = NULL;  
-    VARIANT         variantEmployeeID;
+    VARIANT         variant;
 
     try
     {
         TESTHR( pCommand.CreateInstance( __uuidof( Command ) ) );
-        pCommand->CommandText = "SELECT * FROM orders WHERE EmployeeID = ? ORDER BY
OrderDate";
+        pCommand->CommandText = "SELECT * FROM orders WHERE CustomerID = '?'";
+//        pCommand->CommandText = "SELECT * FROM orders WHERE EmployeeID = ? ORDER BY
OrderDate";
         pCommand->CommandType = adCmdText;
 
-        variantEmployeeID.vt    = VT_I2;
-        variantEmployeeID.iVal  = 4;
-        pParameter = pCommand->CreateParameter( "EmployeeID", adInteger, adParamInput,
sizeof(int), variantEmployeeID );
+        variant.vt      = VT_BSTR;
+        variant.bstrVal = _bstr_t( "WELLI" );
+
+        pParameter = pCommand->CreateParameter( "", adBSTR, adParamInput, 6, variant
);
         pCommand->Parameters->Append( pParameter );
-        pParameter->Value  = variantEmployeeID;
+        pParameter->Value  = variant;
 
+/*
+        variant.vt    = VT_I2;
+        variant.iVal  = 4;
+
+        pParameter = pCommand->CreateParameter( "", adInteger, adParamInput,
sizeof(int), variant );
+        pCommand->Parameters->Append( pParameter );
+        pParameter->Value  = variant;
+*/
         pCommand->ActiveConnection = pConnection;
         pRecordset = pCommand->Execute( NULL, NULL, adCmdText ); 
 
@@ -275,8 +285,6 @@
     if ( FAILED( ::CoInitialize( NULL ) ) )
         return;
 
-    TESTHR( CoCreateInstance( CLSID_OLEDB_CONVERSIONLIBRARY, NULL, CLSCTX_INPROC_SERVER,
IID_IDataConvert, (void **)&pDataConvert) );
-
     /* do it */
     if ( doConnect() )
     {