|
declare the friend as protected
|
|
|
|
|
I've made an SDI Appl with DB Support by MFC Wizard. now in an ADmin module i validat the password supplied by the Administrator and open a Modal Dlg Box with certain Edit Text fields radio buttons.
I've 4 buttons in it.
1) Add
2) Inventory
3) Edit
4) Exit.
On addition i want to add the values in these fields to the DB. but i'm not able to add the member variables to m_pSet-><Field_Name> values to that of the edit text boxes. also I ve a field as accession number(1111-9999) which is a p_key. while we add an item the greatest acc. no. has to be read n a next gr8er no needs to be gen. associated with the item.
The basic prob is how to update data without closing the Dlg Box.
 I know this is a lengthy one...plz bear with it.
Success makes life easier. It doesn't make living easier.
SH UVIK
|
|
|
|
|
|
No i cant let a user access the SDI window when he/she is accessing the Dlg Box.
I just used DDX but still until the Modal Dlg Box Closes I'm not able to invoke update to DB.
how to do it
Success makes life easier. It doesn't make living easier.
SH UVIK
|
|
|
|
|
shouvik.d wrote: No i cant let a user access the SDI window when he/she is accessing the Dlg Box.
Disable the SDI window while the dialog box is active. MFC simulates modal dialog boxes exactly in this way, creating a modeless dialog box from template, disabling main window if any, display the dialog, and reenable the main window after.
Another possibility is to inform application from the modal dialog to perform the update.
This way you don't have to wait the dialog to close, such as in
void CDlg::OnButtonClicked()
{
CData data;
static_cast<CSDIApp *>(AfxGetApp())->updateDatabase(&data);
}
and
void CSDIApp::updateDatabase(CData *pData)
{
}
|
|
|
|
|
firstly thr is no CData class only CDatabase is available.
and plz can u throw a bit more light into this. I'm an amateur n very new to VC++.
There are only two kinds of people who are really fascinating-people who know absolutely everything, and people who know absolutely nothing.
Oscar Wilde (1854-1900)
SH UVIK
|
|
|
|
|
I mean CData as a placeholder for your data, you should implement it yourself as a mean to communicate between the dialog and the application object. In this way, you can collect data from the dialog, declare and fill a structure or class (this is CData) and pass it to the application (or whatever other object you want to delegate for operating in database).
|
|
|
|
|
This is what when the admin module has to be invoked. A passsword validation is done. Later the Admin window opens.
void CLibManView::OnAdmin()
{
Pass p1;
p1.DoModal();
CString str,query,str1;
int flag = 0;
str=p1.m_pass;
m_pSet->Close();
query = "Select * from Password where User='Admin'";
m_pSet->Open(CRecordset::dynaset, (LPCTSTR)query,CRecordset::none);
m_pSet->MoveFirst();
while(!m_pSet->IsEOF())
{
str1=m_pSet->m_Pass;
if(str1==str)
{
flag=1;
break;
}
m_pSet->MoveNext();
}
if(0==flag)
MessageBox("Wrong Password");
else
{
ad.DoModal();
m_pSet->Close();
char temp[2];
itoa(ad.type,temp,2);
char locstat[2];
itoa(2,locstat,2);
query="insert into book values('"+ad.m_Auto_Ac_No+"','"+ad.m_Add_Name+"','"+ad.m_Add_Auth+"',"+temp+","+ad.m_Add_Price+",'"+ad.m_Add_Date+"',"+locstat+")";
m_pSet->Open(CRecordset::dynaset,(LPCTSTR)query,CRecordset::none);
m_pSet->Update();
m_pSet->Close();
}
}
So without closing the Admin dlg box how to update data. also i'm getting an error.
Syntax error in FROM clause on the above query.
plz help
Man can acquire accomplishments or he can become an animal, whichever he wants. God makes the animals, man makes himself.
G. C. Lichtenberg (1742-99), German physicist, philosopher.
SH UVIK
|
|
|
|
|
One method is to do what Cristian Amarie said above. Another is to move the SQL code into the dialog itself.
You may be right
I may be crazy
-- Billy Joel --
Within you lies the power for good, use it!!!
|
|
|
|
|
But i am not able to access the m_pSet-> variable in the Dialog Box.
So how can i update the fields which can be accessed through only the REcordset object m_pSet.
There are only two kinds of people who are really fascinating-people who know absolutely everything, and people who know absolutely nothing.
Oscar Wilde (1854-1900)
SH UVIK
|
|
|
|
|
You can pass the m_pSet pointer to your dialog class when you start the dialog.
You may be right
I may be crazy
-- Billy Joel --
Within you lies the power for good, use it!!!
|
|
|
|
|
plz help
Man can acquire accomplishments or he can become an animal, whichever he wants. God makes the animals, man makes himself.
G. C. Lichtenberg (1742-99), German physicist, philosopher.
SH UVIK
|
|
|
|
|
You got the help already.
1. Pass the database objects as pointers (or references) to the dialog and do the DB work directly inside dialog.
2. Use a messaging mechanism (not especially Windows messages, although could work too) to signal back from dialog to the object that contain your variable m_pRecSet to "do the DB work".
3. Use a separate class that does the DB work, declared by the application object, main window object or where you see this fit, and use a messaging mechanism back and forth to/from this object to any object that require "DB services".
Whenever a DB operation needs to be performed, you must have the means to retrieve and use the DB object, either directly (1), via accesors of other objects (2), or using a convenient object that encapsulates the DB services (3). The solution is up to you, as well as what kind of services can be performed - direct brute queries formatted elsewhere, or using more specialized business logic oriented derived classes.
I suggest you to implement a hierarchy like:
Connection
Statement
StatementWithResults
Recordset
StoredProcedure
...
(whatever you like)
as well as your business objects which can derive from StatementWithResults (1 row in a table) or Recordset for collections.
|
|
|
|
|
hi all,
i am trying to develop a program that requires sending some small mails to some mail-ids, I tried with the code supplied by Nishanth Sivakumar: http://www.codeproject.com/tips/CSMTPConnection2.asp
I am using Visual studio 6.0, and it is not detecting the atlsmtpconnection.h header file. Is this header available in Visual studio-6.0, if yes what setting should I change to get it compiled
Thanx in advance,
SYAMLAL
|
|
|
|
|
SyamlalS wrote: I am using Visual studio 6.0
Read the article you linked to. It specifically says you need VC7 or above.
In the meantime you can use this[^] class in VC6 or even use the Simple MAPI[^] functions.
You may be right
I may be crazy
-- Billy Joel --
Within you lies the power for good, use it!!!
|
|
|
|
|
thank u PJ Arends
SYAMLAL
|
|
|
|
|
|
thank u WhiteSky.
SYAMLAL
|
|
|
|
|
e.g like
GetSubItemRect in mfc , is there any function to fetch the particular RECT from the subitem column and we can display the progress bar in the listview.
amit
|
|
|
|
|
You should be able to calculate it with some combination of
LVM_GETITEMRECT
LVM_GETITEMSPACING
LVM_GETCOLUMN/LVM_GETCOLUMNWIDTH
|
|
|
|
|
Can any one elaborate with example?
basically i did but it shows only one progress bar and it is in the disable form
when i put other item in the list view ,it should be created with new,but it hasn't and other thing when i select it entire row it goes behind the selection, i have some demo but it is in mfc and vc++.
if is there any link or example or demo ?
please guide me.
thank you
amit
|
|
|
|
|
Hi all. Is there a way to prevent ofstream from writing the same line if it already exisits? If so please let me know because i wrote a function that loops the time/date but it keeps on showing the same time/date. Thanx in advance!
Before anyone asks. My code below.
<br />
#include <time.h><br />
#include <windows.h><br />
#include <fstream><br />
using namespace std;<br />
<br />
int main (){<br />
while(1){<br />
Sleep(300);<br />
char date [9];<br />
char time [9];<br />
_strdate(date);<br />
_strtime(time);<br />
ofstream file1;<br />
file1.open("time.txt",ios::app);<br />
file1 << "[Date]: " << date << endl;<br />
file1 << "[Time]: " << time << endl;<br />
file1.close();<br />
}<br />
return 0;<br />
}<br />
Note: the idea is to update when the time changes, not to write the same time over and over until it changes, then write that over and over etc etc.
|
|
|
|
|
int main()
{
char prev_date[9],curr_date[9];
char prev_time[9],curr_time[9];
strcpy(prev_date,"");
strcpy(prev_time,"");
for (;;) {
_strdate(curr_date);
_strtime(curr_time);
if (strcmp(prev_date,curr_date) ||
strcmp(prev_time,curr_time)) {
ofstream file1;
file1.open("time.txt",ios::app);
file1 << "[Date]: " << curr_date << endl;
file1 << "[Time]: " << curr_time << endl;
file1.close();
strcpy(prev_date,curr_date);
strcpy(prev_time,curr_time);
}
}
}
Software Zen: delete this;
|
|
|
|
|
Thanx for your reply, but that function does the same thing as my last one. Printing over and over. Any other suggestions?
|
|
|
|
|
when the criteria for the where condition in a database query that i pumped in through
m_pSet->Open(...,QUERY,...);
and if no records match the criteria i'm gettin an error as
Atttempt to scroll past end or before beginning of data
in a dialog popped up.
What can be the reason.
the code is a follows.
<font size=2>
query="Select * from Book where Name like '%"+name.Left(5)+"%'";
m_pSet->Open(CRecordset::dynaset, (LPCTSTR)query,CRecordset::none);
m_pSet->MoveFirst();
do
{
Item.Empty();
name=m_pSet->m_Name;
auth=m_pSet->m_Author;
Item=m_pSet->m_Ac_No+"\t"+name+"\t"+auth+"\t"+CLibManView::GetStatus(m_pSet->m_Stat);
lb->AddString(Item);
m_pSet->MoveNext();
}while(!m_pSet->IsEOF());
</font>
plz help
Success makes life easier. It doesn't make living easier.
SH UVIK
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
