Click here to Skip to main content
16,012,223 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
QuestionHow do you properly usethe Doc/View Pin
Larry Mills Sr20-Nov-04 11:45
Larry Mills Sr20-Nov-04 11:45 
AnswerRe: How do you properly usethe Doc/View Pin
qcha0s20-Nov-04 12:06
qcha0s20-Nov-04 12:06 
GeneralIncrementing object names in MFC Pin
Sgt.Xyclone20-Nov-04 9:33
Sgt.Xyclone20-Nov-04 9:33 
GeneralRe: Incrementing object names in MFC Pin
PJ Arends20-Nov-04 9:54
professionalPJ Arends20-Nov-04 9:54 
QuestionSNMP Anyone? Pin
qcha0s20-Nov-04 7:12
qcha0s20-Nov-04 7:12 
AnswerRe: SNMP Anyone? Pin
BaldwinMartin20-Nov-04 17:09
BaldwinMartin20-Nov-04 17:09 
AnswerRe: SNMP Anyone? Pin
Henry miller22-Nov-04 2:52
Henry miller22-Nov-04 2:52 
Generalwould like to launch request "SHOW TABLE STATUS LIKE 'Clients'" in VC++ Pin
Member 124237320-Nov-04 4:43
Member 124237320-Nov-04 4:43 
Hello,
I wrote an appli in VC++ that interfaces a database MySQL to store my data, both are linked by ODBC.
I would like to avoid to make too many costly DB extractions in my DB to fill a list, I would like to verify if my DB table content has been modified till last extraction.
Looking at MySQL doc, I found the request "SHOW TABLE STATUS LIKE 'Clients'" that returns a certain numbre of infos on the table and, in particular, the date/time of last update.
But, I have no idea on the way to launch this request from VC++ and retrieve the infos.
Hereunder is what I usually do to send my requestes (i.e. for a select):
---------------------------------------------
DBName = GlobalDSNIGS + ";UID=;PWD:";
res = "SELECT CleClients,CL_Lastname,CL_Firstname from Clients WHERE (CleClients > 0)";
gDB.OpenEx(DBName,CDatabase::noOdbcDialog);
TRY
{
rs.Open( CRecordset::forwardOnly, res );
NbRecord = rs.GetRecordCount();
}
CATCH(CDBException, e)
{
ErrMsg ="**ERR: "+e->m_strError;
}
END_CATCH
if ((ErrMsg == "") && (NbRecord > 0)){
while(!rs.IsEOF()) {
rs.GetFieldValue( "CleClients", Nbr);
rs.GetFieldValue( "CL_Lastname", Lastname);
rs.GetFieldValue( "CL_Firstname", Firstname);
ID = BLANK.Left(10-strlen(Nbr)) + Nbr; // justify on 10 char
// m_GuestsList.AddString(Lastname + "-" +Firstname+" / Guest# : "+ID);
rs.MoveNext();
}
}
rs.Close();
gDB.Close();
-------------------------------------------------------------
Is there a way to do this or even onother way to retrieve this last date/time infos?
Thanks in advance for you answer
DD
QuestionHow do I know when CDialog is deleted by a destructor? Pin
tip231020-Nov-04 4:25
tip231020-Nov-04 4:25 
AnswerRe: How do I know when CDialog is deleted by a destructor? Pin
Maximilien20-Nov-04 5:29
Maximilien20-Nov-04 5:29 
GeneralRe: How do I know when CDialog is deleted by a destructor? Pin
tip231020-Nov-04 6:00
tip231020-Nov-04 6:00 
GeneralRe: How do I know when CDialog is deleted by a destructor? Pin
Maximilien20-Nov-04 6:08
Maximilien20-Nov-04 6:08 
GeneralRe: How do I know when CDialog is deleted by a destructor? Pin
tip231020-Nov-04 6:20
tip231020-Nov-04 6:20 
GeneralRe: How do I know when CDialog is deleted by a destructor? Pin
Maximilien20-Nov-04 9:14
Maximilien20-Nov-04 9:14 
GeneralWIN Management WMI Service (64 bit env on IA-64) doesn't seem to load 32 bit dlls Pin
Member 39957420-Nov-04 3:28
Member 39957420-Nov-04 3:28 
GeneralRe: WIN Management WMI Service (64 bit env on IA-64) doesn't seem to load 32 bit dlls Pin
BaldwinMartin20-Nov-04 17:04
BaldwinMartin20-Nov-04 17:04 
GeneralRe: WIN Management WMI Service (64 bit env on IA-64) doesn't seem to load 32 bit dlls Pin
Member 39957420-Nov-04 19:49
Member 39957420-Nov-04 19:49 
GeneralRe: WIN Management WMI Service (64 bit env on IA-64) doesn't seem to load 32 bit dlls Pin
BaldwinMartin21-Nov-04 7:28
BaldwinMartin21-Nov-04 7:28 
GeneralRe: WIN Management WMI Service (64 bit env on IA-64) doesn't seem to load 32 bit dlls Pin
BaldwinMartin22-Nov-04 7:52
BaldwinMartin22-Nov-04 7:52 
Generalperfomance monitor object Counter log issue on Windows 2003(WMI) Pin
Member 39957420-Nov-04 3:24
Member 39957420-Nov-04 3:24 
GeneralRe: perfomance monitor object Counter log issue on Windows 2003(WMI) Pin
Member 39957420-Nov-04 20:18
Member 39957420-Nov-04 20:18 
Generalauthentificated smtp Pin
Spiritofamerica20-Nov-04 3:07
Spiritofamerica20-Nov-04 3:07 
GeneralRe: authentificated smtp Pin
Ravi Bhavnani20-Nov-04 6:20
professionalRavi Bhavnani20-Nov-04 6:20 
GeneralRe: authentificated smtp Pin
BaldwinMartin20-Nov-04 17:19
BaldwinMartin20-Nov-04 17:19 
GeneralC++ program to perform Binary Tree operations Pin
ftrbinom,oiunomin20-Nov-04 2:59
ftrbinom,oiunomin20-Nov-04 2:59 

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.