How to update records on live(remote) database from local machine ...
-
Hi all i am using mysql remote database i am able to connect and retrieve the records from the remote database. But i am unable to update the records. Please healp. see my code; CRecordset cRecord(&db); CString csQuery; csQuery.Format(L"select * from %s where product_name = %s", m_TableName,m_ProductName); cRecord.Open(CRecordset::snapshot, csQuery, CRecordset::none); if(cRecord.IsOpen()) { while(!cRecord.IsEOF()) { cRecord.Edit(); ; //here i have to update the price column please help me cRecord.Update(); cRecord.MoveNext(); }//while(!cRecord.IsEOF()) cRecord.Close(); db.Close(); Thanks in advance
-
Hi all i am using mysql remote database i am able to connect and retrieve the records from the remote database. But i am unable to update the records. Please healp. see my code; CRecordset cRecord(&db); CString csQuery; csQuery.Format(L"select * from %s where product_name = %s", m_TableName,m_ProductName); cRecord.Open(CRecordset::snapshot, csQuery, CRecordset::none); if(cRecord.IsOpen()) { while(!cRecord.IsEOF()) { cRecord.Edit(); ; //here i have to update the price column please help me cRecord.Update(); cRecord.MoveNext(); }//while(!cRecord.IsEOF()) cRecord.Close(); db.Close(); Thanks in advance
jiya-123 wrote:
But i am unable to update the records.
Why not?
jiya-123 wrote:
cRecord.Edit();
Did you first call the
CanUpdate()method to see if the recordset can be updated? Also, are you attempting to catch any exceptions (e.g.,CDBException)?"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"Man who follows car will be exhausted." - Confucius