|
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
|
|
|
|
|
All seem to be on VACATION....;)
Well well...Enjoy...Then do reply...
Success makes life easier. It doesn't make living easier.
SH UVIK
|
|
|
|
|
shouvik.d wrote: and if no records match the criteria i'm gettin an error as
Atttempt to scroll past end or before beginning of data
That's because you are calling MoveFirst when there are no records.
|
|
|
|
|
there are 8 records present in the DB already
Success makes life easier. It doesn't make living easier.
SH UVIK
|
|
|
|
|
shouvik.d wrote: there are 8 records present in the DB already
I am not talking about DB, but about the result returned by the query. Get the count of records before moving around in a recordset.
|
|
|
|
|
thanks
prob solved
I instead did this
m_pSet->Close();
query = "Select * from Book where Ac_no = '"+accnum+"'";
m_pSet->Open(CRecordset::dynaset, (LPCTSTR)query,CRecordset::none);
if(m_pSet->IsBOF() && m_pSet->IsEOF())
MessageBox("No records meeting the criteria");
else
{
m_pSet->MoveFirst();
do
{
name=m_pSet->m_Name;
auth=m_pSet->m_Author;
Item=accnum+"\t"+name+"\t"+auth+"\t"+CLibManView::GetStatus(m_pSet->m_Stat);
lb->AddString(Item);
m_pSet->MoveNext();
}while(!m_pSet->IsEOF());
}
Success makes life easier. It doesn't make living easier.
SH UVIK
|
|
|
|
|
Yeah. Always check status of db query results before using them.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
