database problem
C / C++ / MFC
1
Posts
1
Posters
0
Views
1
Watching
-
Hi All, I am opening database as CDaoDatabase dbSql; dbSql.Open(NULL,FALSE,FALSE,"ODBC;DSN=ITITest;UID=sa;pwd="); CDaoRecordset rsSql; rsSql.m_pDatabase = dbSql; rsSql.Open(dbOpenSnapshot,"SELECT * FROM tbltest"); BOOL TRY1 = rsSql.CanUpdate(); rsSql.SetFieldValue("test1","123"); when this is executed TRY1 is 0, that means I cant update I have to change the data in one field of tbltest at the run time for which I am using SetFieldValue of CDaoRecordset. I am getting following error, "operation is not supported for this type of object" Is this approach is correct?? Can anyone explain me asap Thanks in advance Uday