Steps to Reproduce the Behavior

1. Create a table in SQL Server with an image field.

   Table Name: DemoTab

   Collapse this tableExpand this table

   Field Name	Data Type
   field1	int
   field2	image

2. Use the Active Template Library (ATL) OLE DB Consumer Wizard to create a CCommand class that will be used to open up a rowset on the table. The wizard will generate code similar to the following in the accessor class:

   	BLOB_ENTRY(2, IID_ISequentialStream, STGM_READ, m_field2)
   					

   Note In Visual C++ .NET, the wizard generates code for using the ISequentialStream object in comments. If you want to use this object, you must uncomment these lines in the generated code. The accessor class will be similar to the following:

   BLOB_ENTRY_LENGTH_STATUS(2, IID_ISequentialStream, STGM_READ, m_field2, m_dwfield2Length, m_dwfield2Status)
   					

3. Using the new CCommand derived class, add the following:

   HRESULT hr;
      CMyCommand rs;
      rs.Open();
      rs.MoveNext();<BR/>
   // rs.m_field2->Release(); //un-comment these two lines to fix the error 
   //rs.m_field2 = NULL;
      hr = rs.Delete(); 
   					

   You will notice that E_UNEXPECTED is returned from the Delete() call.

Back to the top