• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 605
  • Last Modified:

CRecordset update record causing assertion failure

Dear:
I have problem when try to update a record using CRecordset , that when make
TRY ...CATCH and error message said [Recordset is Readonly],
what I did i build MFC Application then , I added new Class derived from
CRecordset and did the following code inside OnInitDialogue:

CClients dbRecord;// CClient my derived class from CRecordset
dbRecord.Edit();//here Debug assertion failure occurred;
dbRecord.m_Address = "FL";
...
....
..
dbRecord.Update();

any ideas?


Regards

0
raed_hasan
Asked:
raed_hasan
  • 3
1 Solution
 
AndyAinscowFreelance programmer / ConsultantCommented:
You posted the answer yourself.
error message said [Recordset is Readonly]

you CAN'T edit a readonly recordset.
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
Is your recordset based on a query?  If yes then your query may not be editable (groups/sums information, joins to other tables, there are a number of reasons why it might not be editable).

Is the database itself readonly?  Do you only have read allowances to the table in the database?  Is the database on a drive/directory you don't have write permissions for?
0
 
raed_hasanAuthor Commented:
Ok, but what i need is how to disable Readonly property in CRecordset cause , i did the following code:

CDatabase dbConnection;
dbConnection.OpenEx("DSN=TestDB;uid=sa;pwd=");

//dbConnection.Open("ODBC;DSN=SQL Server;UID=sa;PWD=");
CRecordset dbRecord(&dbConnection);
//SQL Select Statement
char  Sql[1024] = "UPDATE Clients SET Counter = 1 WHERE ClientID = '";
strcat(Sql,"000000000402");
strcat(Sql,"'");
TRY
{
     dbRecord.Open(CRecordset::snapshot,Sql,CRecordset::none);//Assertion Failure here
    //in Assertion Message Box ( File Name : dbCore.cpp) (Line: 3282)


}
CATCH(CDBException,e)
{
      char s[256]="\0";
      strcpy(s,e->m_strError);

}
END_CATCH



Regards
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
The SQL statement begins with UPDATE - that is a command to manipulate the contents of a table/query.  It is NOT used to return records.  A statement like that is typically used as follows

dbConnection.ExecuteSQL(Sql);
0
 
rpatnaCommented:
try this:
CDatabase      database;

if(!database.Open(_T(<dsnName>),FALSE,FALSE,_T("ODBC;")))
{
      return 0;      // if DataBase not opened
}
CRecordset      recSet(&database);
CString            sqlCmd;
sqlCmd      =      "SELECT * ";
sqlCmd  +=      "FROM BIT_SYNC WHERE SetupName = ";
sqlCmd      +=      "'";
sqlCmd      +=  setupName;
sqlCmd      +=      "'";
if(!recSet.Open( CRecordset::forwardOnly,_T( sqlCmd ) ))
{
      if (database.IsOpen())
             database.Close();
             return FALSE;
}
CDBVariant      dbVariant;
while( !recSet.IsEOF( ) )
{
index = 1;
recSet.GetFieldValue( index++, dbVariant );
rBitSyncData->source = dbVariant.m_chVal;
. . .

}
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now