OLE DB Consumer Templates - Updating DB With DynamicAccessor

Hello,
I'd like to use OLE DB consumer templates, but I have troubles with changing values in my test DB. I've created a simple MS access DB 'ZK2Test.mdb' with one table 'pokus'. This table consist of one column with number (short integer).
I can read values, thats works fine. But when I try to write something, it is not propagated into DB.
I call SetValue and Update on cTable object and every call returns S_OK. When I try to read value of first row after my write, I get my new value of first column. But after moving cursor somewhere else and back to first row, reading first column of first row returns again the previous value.

In code example is my attempt to change value 1 from first row to 421
Sequence of commands is (C1 means Column 1):


MoveFirst
GetValue(C1) = 1
SetValue(421 to C1)
Update()
GetValue(C1) = 421

MoveNext()
MoveFirst()
GetValue(C1) = 1

Could anybody please tell me, what is wrong?

Thanks for your answers






Code Snippet

CDataSource DTSrc;
CSession DTSession;
CTable<CDynamicAccessor, CRowset> cTable;

// Open DB
res = DTSrc.Open (L"Microsoft.Jet.OLEDB.4.0", "..\ZK2Test.mdb");
CHECK_RES(res);
res = DTSession.Open(DTSrc);
CHECK_RES(res);
CDBPropSet propset(DBPROPSET_ROWSET);
propset.AddProperty(DBPROP_IRowsetUpdate, true);
propset.AddProperty(DBPROP_UPDATABILITY, DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE);
res = cTable.Open(DTSession, L"pokus", &propset);
CHECK_RES(res);

// Move to first row
res = cTable.MoveFirst();
CHECK_RES(res);

dataPtr = cTable.GetValue(1);
x = *((SHORT*)dataPtr);
// Now the value of x is 1

x = 421;
if (!cTable.SetValue(1, x)) {
return FALSE;
}
res = cTable.Update();
CHECK_RES(res);

dataPtr = cTable.GetValue(1);
x = *((SHORT*)dataPtr);
// Now the value of x is 421

// Move cursor to the second row and back
res = cTable.MoveNext();
res = cTable.MoveFirst();
dataPtr = cTable.GetValue(1);
x = *((SHORT*)dataPtr);
// Now the value of x is 1 (the original value, WHY!?)