Click here to Skip to main content
16,016,605 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: need help in CListCtrl Pin
Christian Graus22-Aug-05 18:24
protectorChristian Graus22-Aug-05 18:24 
GeneralRe: need help in CListCtrl Pin
firebolt7722-Aug-05 18:57
firebolt7722-Aug-05 18:57 
GeneralRe: need help in CListCtrl Pin
Christian Graus22-Aug-05 19:01
protectorChristian Graus22-Aug-05 19:01 
GeneralRe: need help in CListCtrl Pin
firebolt7722-Aug-05 20:05
firebolt7722-Aug-05 20:05 
GeneralRe: need help in CListCtrl Pin
ThatsAlok22-Aug-05 22:57
ThatsAlok22-Aug-05 22:57 
GeneralRe: need help in CListCtrl Pin
firebolt7723-Aug-05 19:42
firebolt7723-Aug-05 19:42 
GeneralRe: need help in CListCtrl Pin
ThatsAlok23-Aug-05 19:58
ThatsAlok23-Aug-05 19:58 
GeneralUpdating a field in Access database Pin
joy00722-Aug-05 18:12
joy00722-Aug-05 18:12 
Hi guys,
I am using an Access database in my application.
The problem arises then when I try to update or edit a field corresponding to another field in the data base.
Consider the database contains 2 fields,namely m_NameE2 and m_NameB2.
Now I try searching out the m_NameE2 field for a given text,if found then I go for updating the corresponding m_NameB2 field.But it gives like such errors
"CRecordset is read-only"-when I use rs.Edit(),or "Attempt to Update or delete failed" for rs.Update();

I use the following code:

<br />
	CString ss,gg;<br />
	int present=0;<br />
    GetDlgItemText(IDC_EDIT1,ss);<br />
	gg=m_gedit.Get_Text();<br />
	if(ss!="" && gg!="")<br />
	{<br />
		CDatabase db;<br />
	  db.OpenEx(_T("DSN=ForeignName"),CDatabase::noOdbcDialog);<br />
	  if(db.CanUpdate()==TRUE)<br />
	  {<br />
	    CNameRecords  rs(&db);<br />
		rs.Open(CRecordset::dynaset);<br />
		rs.MoveFirst();<br />
<br />
		do<br />
		{<br />
				if(rs.m_NameE2==ss)<br />
				{<br />
					present=1;<br />
					AfxMessageBox("Data found and will be tried for modifying");<br />
					break;<br />
				}<br />
				rs.MoveNext();<br />
		}while(rs.IsEOF()!=TRUE);<br />
<br />
        if(present==0)<br />
		{<br />
			AfxMessageBox("Data not found in English Name column !!");<br />
		   <br />
		}<br />
	    <br />
	    else<br />
		{<br />
			<br />
			rs.Edit();<br />
			rs.m_NameB2=gg;<br />
		<br />
			rs.Update();<br />
			<br />
			SetDlgItemText(IDC_EDIT2,rs.m_Sex2);<br />
				SetDlgItemText(IDC_EDIT3,rs.m_Origin2);<br />
			 AfxMessageBox("Data is saved successfully");<br />
<br />
		}<br />
		rs.Close();<br />
	    //AfxMessageBox("Data is present in database,enter a new one");<br />
		//m_save.EnableWindow(FALSE);<br />
	  }<br />
	  else<br />
		  AfxMessageBox("Data is not saved,because data can't be appended in database file !!!!... ");<br />
	  db.Close();<br />
	}<br />
	else<br />
	{<br />
	  AfxMessageBox("Data is not saved,because the fields are partially or not filled at all !!!!... ");<br />
	  //m_save.EnableWindow(FALSE);<br />
	}<br />
<br />
	<br />


Please help...
GeneralRe: Updating a field in Access database Pin
Jose Lamas Rios22-Aug-05 18:27
Jose Lamas Rios22-Aug-05 18:27 
GeneralRecieving a file over TCP Pin
Member 183908222-Aug-05 17:56
Member 183908222-Aug-05 17:56 
GeneralRe: Recieving a file over TCP Pin
Jose Lamas Rios22-Aug-05 18:04
Jose Lamas Rios22-Aug-05 18:04 
GeneralRe: Recieving a file over TCP Pin
Member 183908222-Aug-05 18:13
Member 183908222-Aug-05 18:13 
GeneralRe: Recieving a file over TCP Pin
Jose Lamas Rios22-Aug-05 19:10
Jose Lamas Rios22-Aug-05 19:10 
GeneralRe: Recieving a file over TCP Pin
Member 183908223-Aug-05 7:44
Member 183908223-Aug-05 7:44 
GeneralRe: Recieving a file over TCP Pin
Member 183908223-Aug-05 17:10
Member 183908223-Aug-05 17:10 
Questionhow to create a listbox using GLUI. Pin
jasrina22-Aug-05 17:45
jasrina22-Aug-05 17:45 
AnswerRe: how to create a listbox using GLUI. Pin
Jose Lamas Rios22-Aug-05 18:02
Jose Lamas Rios22-Aug-05 18:02 
GeneralTree List Control Pin
Nishad S22-Aug-05 17:45
Nishad S22-Aug-05 17:45 
GeneralRe: Tree List Control Pin
Jose Lamas Rios22-Aug-05 18:08
Jose Lamas Rios22-Aug-05 18:08 
QuestionHow to make text link in dialog box with Win32api? Pin
Member 159461422-Aug-05 16:55
Member 159461422-Aug-05 16:55 
AnswerRe: How to make text link in dialog box with Win32api? Pin
Jose Lamas Rios22-Aug-05 17:05
Jose Lamas Rios22-Aug-05 17:05 
GeneralRe: How to make text link in dialog box with Win32api? Pin
Member 159461422-Aug-05 18:01
Member 159461422-Aug-05 18:01 
GeneralRe: How to make text link in dialog box with Win32api? Pin
Jose Lamas Rios22-Aug-05 18:05
Jose Lamas Rios22-Aug-05 18:05 
QuestionInternet game? Pin
gr8coaster32922-Aug-05 16:14
gr8coaster32922-Aug-05 16:14 
QuestionHow can i chang the type of int to type of POSITION Pin
ebinaini22-Aug-05 15:14
ebinaini22-Aug-05 15:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.