-- Create the following table in SQL Server database
CREATE TABLE [dbo].[identtesttable] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[test] [char] (10) NULL )
go
insert into [dbo].[identtesttable] values ("Test")
go	
				

/* Use the ATL database wizard to generate a command and accessor
for the above table which has an identity column. <BR/>
Modify the wizard generated accessor to bind field status as well as data.

Use the COLUMN_ENTRY_STATUS macro instead of the COLUMN_ENTRY macro. 
*/ 
class CdboIdentTestTableAccessor
{
public:
	TCHAR m_id[11];
        TCHAR m_test[11];
	DBSTATUS m_idStatus;
	DBSTATUS m_TestStatus;
        BEGIN_COLUMN_MAP(CdboIdentTestTableAccessor)
	       COLUMN_ENTRY_STATUS(1,m_id,m_idStatus)
               COLUMN_ENTRY_STATUS(2, m_test,m_TestStatus)
        END_COLUMN_MAP()

        DEFINE_COMMAND(CdboIdentTestTableAccessor, 
                       _T("SELECT id, test FROM dbo.IdentTestTable"))

// You may wish to call this function if you are inserting a record and wish to
	// initialize all the fields, if you are not going to explicitly set all of them.
	void ClearRecord()
	{
		memset(this, 0, sizeof(*this));
	}
};

class CdboIdentTestTable : public CCommand<CAccessor<CdboIdentTestTableAccessor> >
{
public:
	HRESULT Open()
	{
		HRESULT		hr;
hr = OpenDataSource();
		if (FAILED(hr))
			return hr;

		return OpenRowset();
	}
	HRESULT OpenDataSource()
	{
		HRESULT		hr;
		CDataSource db;
		CDBPropSet	dbinit(DBPROPSET_DBINIT);

		dbinit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, false);		dbinit.AddProperty(DBPROP_AUTH_USERID, OLESTR("sa"));	dbinit.AddProperty(DBPROP_INIT_CATALOG, OLESTR("yourdatabase"));	dbinit.AddProperty(DBPROP_INIT_DATASOURCE, OLESTR("yourserver"));	dbinit.AddProperty(DBPROP_INIT_LCID, (long)1033);	dbinit.AddProperty(DBPROP_INIT_PROMPT, (short)4);

hr = db.Open(_T("SQLOLEDB.1"), &dbinit);
		if (FAILED(hr))
			return hr;

		return m_session.Open(db);
	}
	HRESULT OpenRowset()
	{
		// Set properties for open
		CDBPropSet	propset(DBPROPSET_ROWSET);
		propset.AddProperty(DBPROP_IRowsetChange, true);
		propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE);

		return CCommand<CAccessor<CdboIdentTestTableAccessor> >::Open(m_session, NULL, &propset);
	}
	CSession	m_session;
};

// Test Code, attempt to update the rowset by calling CRowset::SetData() on the CCommand object 

	CdboIdentTestTable rs;

	HRESULT hr = rs.Open();
	hr = rs.MoveNext();

	// Update the test field
	strcpy(rs.m_test,"test3");
	rs.m_idStatus = DBSTATUS_S_IGNORE;
	hr=rs.SetData(); // ------->> will return DB_ERRORSOCCURRED 

	// insert a new reoord
	rs.ClearRecord();
	strcpy ( rs.m_test, "New");
	rs.m_idStatus = DBSTATUS_S_IGNORE;
	hr=rs.Insert();

	rs.Close();