Click here to Skip to main content
15,905,785 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Porting from Win2000 to WinXP Pin
Ravi Bhavnani26-Sep-05 5:57
professionalRavi Bhavnani26-Sep-05 5:57 
GeneralRe: Porting from Win2000 to WinXP Pin
mckavity26-Sep-05 6:53
mckavity26-Sep-05 6:53 
GeneralRe: Porting from Win2000 to WinXP Pin
Ravi Bhavnani26-Sep-05 7:07
professionalRavi Bhavnani26-Sep-05 7:07 
GeneralRe: Porting from Win2000 to WinXP Pin
David Crow26-Sep-05 5:58
David Crow26-Sep-05 5:58 
AnswerRe: Porting from Win2000 to WinXP Pin
Michael Dunn26-Sep-05 8:14
sitebuilderMichael Dunn26-Sep-05 8:14 
Questionusing CDatabase writing into excel files Pin
26-Sep-05 3:54
suss26-Sep-05 3:54 
AnswerRe: using CDatabase writing into excel files Pin
David Crow26-Sep-05 4:49
David Crow26-Sep-05 4:49 
GeneralRe: using CDatabase writing into excel files Pin
tejaswi-teja26-Sep-05 5:51
tejaswi-teja26-Sep-05 5:51 
sSql.Format("DRIVER={%s};DSN='';FIRSTROWHASNAMES=1;READONLY=FALSE;CREATE_DB=\"%s\";DBQ=%s", sDriver,gsExcelFileName,gsExcelFileName);
if( database.OpenEx(sSql,CDatabase::noOdbcDialog) )
{
//Create table structure
sSql = "Create Table MIDs ( ECMName TEXT,MID_Hex TEXT,MID_Dec TEXT,GroupBroadcast TEXT,ME_Number TEXT,AlarmLevel TEXT,SpecialWarning TEXT,AbuseType TEXT,ParameterName TEXT,Status TEXT,Instruction TEXT,MID TEXT,CID TEXT,DeleteCIDs TEXT,Display TEXT,Log TEXT,ServiceLamp TEXT,Telemetry TEXT,EventRecorder TEXT,ESET TEXT,Start TEXT,Actuate TEXT,Deactuate TEXT,Acknowledge TEXT,ServiceLight TEXT )";
//HistogramID number, HIstogramFormula TEXT)";
database.ExecuteSQL(sSql);
.
.
.
.
.



// The below is all sqlstatement how it is constructed. ValuesString.Format("'%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s'",ControlValueArray[44][1],MIDHexValue,ControlValueArray[43][1],ControlValueArray[2][1],ControlValueArray[3][1],AlaramLevel,ControlValueArray[38][1],ControlValueArray[39][1],ControlValueArray[44][1],ControlValueArray[41][1],ControlValueArray[42][1],ControlValueArray[43][1],ControlValueArray[4][1],DeleteCIDs,ControlValueArray[32][1],ControlValueArray[31][1],ControlValueArray[30][1],ControlValueArray[29][1],ControlValueArray[33][1],ControlValueArray[28][1],"N/A",ControlValueArray[15][1],ControlValueArray[16][1],ControlValueArray[17][1],ControlValueArray[18][1] );
sSql = "INSERT INTO MIDs(ECMName ,MID_Hex ,MID_Dec ,GroupBroadcast ,ME_Number ,AlarmLevel ,SpecialWarning ,AbuseType ,ParameterName ,Status ,Instruction ,MID ,CID ,DeleteCIDs ,Display ,Log ,ServiceLamp ,Telemetry ,EventRecorder ,ESET ,Start ,Actuate ,Deactuate ,Acknowledge ,ServiceLight ) VALUES ("+ ValuesString+ ")";



database.ExecuteSQL(sSql);

database.Close();

Like this it is adding to excel.
GeneralRe: using CDatabase writing into excel files Pin
David Crow26-Sep-05 6:02
David Crow26-Sep-05 6:02 
GeneralRe: using CDatabase writing into excel files Pin
tejaswi-teja26-Sep-05 19:39
tejaswi-teja26-Sep-05 19:39 
GeneralRe: using CDatabase writing into excel files Pin
David Crow27-Sep-05 2:46
David Crow27-Sep-05 2:46 
GeneralRe: using CDatabase writing into excel files Pin
tejaswi-teja27-Sep-05 3:23
tejaswi-teja27-Sep-05 3:23 
QuestionEstimate distance Pin
bulgaa26-Sep-05 3:41
bulgaa26-Sep-05 3:41 
AnswerRe: Estimate distance Pin
David Crow26-Sep-05 4:50
David Crow26-Sep-05 4:50 
JokeRe: Estimate distance Pin
toxcct26-Sep-05 5:11
toxcct26-Sep-05 5:11 
GeneralRe: Estimate distance Pin
Maximilien26-Sep-05 7:08
Maximilien26-Sep-05 7:08 
QuestionHow to get the ASCII-decimal-value of an character? Pin
MDT Daniel26-Sep-05 2:26
MDT Daniel26-Sep-05 2:26 
AnswerRe: How to get the ASCII-decimal-value of an character? Pin
David Crow26-Sep-05 2:31
David Crow26-Sep-05 2:31 
AnswerRe: How to get the ASCII-decimal-value of an character? Pin
Kenan Aksoy26-Sep-05 4:51
Kenan Aksoy26-Sep-05 4:51 
QuestionProblem in CWinApp::Initinstance of SDI App Pin
Manfred Staiger26-Sep-05 2:26
Manfred Staiger26-Sep-05 2:26 
AnswerRe: Problem in CWinApp::Initinstance of SDI App Pin
prasad_som26-Sep-05 2:49
prasad_som26-Sep-05 2:49 
GeneralMy own fault Pin
Manfred Staiger26-Sep-05 3:43
Manfred Staiger26-Sep-05 3:43 
QuestionHow to get the HANDLE of the running EXE? Pin
Amarelia26-Sep-05 2:18
Amarelia26-Sep-05 2:18 
AnswerRe: How to get the HANDLE of the running EXE? Pin
David Crow26-Sep-05 2:22
David Crow26-Sep-05 2:22 
AnswerRe: How to get the HANDLE of the running EXE? Pin
bugDanny26-Sep-05 2:57
bugDanny26-Sep-05 2:57 

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.