C / C++ / MFC Discussion Boards

Re: using CDatabase writing into excel files

tejaswi-teja26-Sep-05 5:51

26-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.

Re: using CDatabase writing into excel files

David Crow26-Sep-05 6:02

David Crow

26-Sep-05 6:02

Did you look at how ValuesString is being constructed? The cause of your ' problem is right there? Confused | :confused:

"One must learn from the bite of the fire to leave it alone." - Native American Proverb

Re: using CDatabase writing into excel files

tejaswi-teja26-Sep-05 19:39

tejaswi-teja

26-Sep-05 19:39

i did not get whatu are telling. actually all those values in the values string are text values. so them i have written as 'content' .

because in the sql sltatement they should be given as

insert into tablename values('text1','text2',number e.t.c);
so have used format('%s', variablevalue) for forming ValuesString .

just now have seen while trying to print into number fields it is giving normally but while printing text values , the value of the cell is shown as normally only but preceded by a ' symbol when double clicking on the cell.

after dblclk on cell the value is like '1234 for text,

copy cell contents and paste it elsewhere in note pad they appearing like:

ECMName MID_Hex
peninsula 5678

Re: using CDatabase writing into excel files

David Crow27-Sep-05 2:46

David Crow

27-Sep-05 2:46

tejaswi_teja wrote:
i did not get whatu are telling. actually all those values in the values string are text values. so them i have written as 'content' .

because in the sql sltatement they should be given as

insert into tablename values('text1','text2',number e.t.c);
so have used format('%s', variablevalue) for forming ValuesString .

I understand now.

tejaswi_teja wrote:
just now have seen while trying to print into number fields it is giving normally but while printing text values , the value of the cell is shown as normally only but preceded by a ' symbol when double clicking on the cell.

after dblclk on cell the value is like '1234 for text,

copy cell contents and paste it elsewhere in note pad they appearing like:

ECMName MID_Hex
peninsula 5678

Since the single quote marks in each cell are for display purposes only (they tell Excel to treat the text exactly as you have entered it), and does not affect printing or pasting to other applications, is there any harm in leaving them there?

"One must learn from the bite of the fire to leave it alone." - Native American Proverb

Re: using CDatabase writing into excel files

tejaswi-teja27-Sep-05 3:23

tejaswi-teja

27-Sep-05 3:23

nothing harm just. just i was afraid if sbdy access the contents of that file along its original contents these quotes may also come and disturb. thats why. no other problems.

Estimate distance

bulgaa26-Sep-05 3:41

bulgaa

26-Sep-05 3:41

Hello

I want to estimate distance between 2 distributions.

Which distance function more efficent?
If know any distance function, tell me that distance function name, pls?

Thank you so much

Re: Estimate distance

David Crow26-Sep-05 4:50

David Crow

26-Sep-05 4:50

bulgaa wrote:
I want to estimate distance between 2 distributions.

Do you mean a Linux distribution? If not, please explain what a distribution is.

"One must learn from the bite of the fire to leave it alone." - Native American Proverb

Re: Estimate distance

toxcct26-Sep-05 5:11

toxcct

26-Sep-05 5:11

DavidCrow wrote:
If not, please explain what a distribution is.

and so, what "distance" is !
Wink | ;)

TOXCCT >>> GEII power
[toxcct][VisualCalc]

Re: Estimate distance

Maximilien26-Sep-05 7:08

Maximilien

26-Sep-05 7:08

Maximilien Lincourt
Your Head A Splode - Strong Bad

How to get the ASCII-decimal-value of an character?

MDT Daniel26-Sep-05 2:26

MDT Daniel

26-Sep-05 2:26

Are there any functions in C++ to get an ASCII-decimal-value of
an character?
for example: IN = 'A' -> OUT = 65

Re: How to get the ASCII-decimal-value of an character?

David Crow26-Sep-05 2:31

David Crow

26-Sep-05 2:31

Sure.

char c = 'A';
int val = c; // val equals 65

"One must learn from the bite of the fire to leave it alone." - Native American Proverb

Re: How to get the ASCII-decimal-value of an character?

Kenan Aksoy26-Sep-05 4:51

Kenan Aksoy

26-Sep-05 4:51

atoi(char*) may work,if it does not, try to convert charvariable to char*. sprintf may be right function.

dlfkgj lsdfkglfkgjlfgl jldfk fldkk jk

Problem in CWinApp::Initinstance of SDI App

Manfred Staiger26-Sep-05 2:26

Manfred Staiger

26-Sep-05 2:26

In my SDI Application the following problem appeared all of a sudden: In the InitInstance function of the application class the following line

// Dispatch commands specified on the command line
if (!ProcessShellCommand(cmdInfo))
return FALSE;

causes the error:

Error creating empty document ! (Translation from german, so the english errortext may be slightly different)

Tracing into the MFC code the error happens in the function CWinApp::ProcessShellCommand at the following statement:

if (!AfxGetApp()->OnCmdMsg(ID_FILE_NEW, 0, NULL, NULL))

Does anybody else have had this problem and found a solution ???

MS

Re: Problem in CWinApp::Initinstance of SDI App

prasad_som26-Sep-05 2:49

prasad_som

26-Sep-05 2:49

This happens due to failure of creating frame window.
check your CMainFrame::PreCreateWindow function.
It may returning FALSE.
Narrow down the problem by commenting whole code in this function and un comment one by one.
You will definitely get problem.
else
carry the same check on OnCreate() function.

-- modified at 9:00 Monday 26th September, 2005

My own fault

Manfred Staiger26-Sep-05 3:43

Manfred Staiger

26-Sep-05 3:43

Oh such a sh*t. I had some old code in the views PreCreateWindow function which fails at the current version of the project. And so the creation of the view fails.

MS

How to get the HANDLE of the running EXE?

Amarelia26-Sep-05 2:18

Amarelia

26-Sep-05 2:18

Hi
I want to terminate one application which is running but for that I m not able to get the caption, classname or anything by GetWindowText or FindWindow().

Is there any way so that I can have HANDLE of that running exe and i can terminate that ?

Regards

Amarelia Maehsh
Gujarat
India

Re: How to get the HANDLE of the running EXE?

David Crow26-Sep-05 2:22

David Crow

26-Sep-05 2:22

Amarelia wrote:
...I m not able to get the caption, classname or anything by GetWindowText or FindWindow().

Why not?

"One must learn from the bite of the fire to leave it alone." - Native American Proverb

Re: How to get the HANDLE of the running EXE?

bugDanny26-Sep-05 2:57

bugDanny

26-Sep-05 2:57

EnumWindows() will cycle through every single window on the machine. Your program should be in there somewhere. You need to provide EnumWindows with a function to call for each window handle. Then try using GetWindowText() or GetClassName(). Most times you can figure out which Window Text or Class Name you are looking for if you use Spy++ (comes with Visual Studio).

Hope this helps!

Danny

Re: How to get the HANDLE of the running EXE?

ThatsAlok26-Sep-05 5:57

ThatsAlok

26-Sep-05 5:57

Amarelia wrote:
I m not able to get the caption, classname or anything by GetWindowText or FindWindow().

After redaing your messages, one of best idea is to save your current handle of window in some INI or registry at starting .. so that other application read it from that common location and perform teh required.. though it not good solution... but it's worth trying it

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

cheers,
Alok Gupta
VC Forum Q&A :- I/ IV

Close application from task manager

Anonymous26-Sep-05 2:15

Anonymous

26-Sep-05 2:15

In Debug Mode, can we remove our application with codes..
Iam opening the winword with my application, without closing the word i closed my appliaction, for the next time while iam running the appliacion an error is showing coz of my applaction still exits in the task manager.. is there any solution for closing my applaiction from the code?

Re: Close application from task manager

David Crow26-Sep-05 2:27

David Crow

26-Sep-05 2:27

Is your application spawning additional threads?

"One must learn from the bite of the fire to leave it alone." - Native American Proverb

Re: Close application from task manager

bugDanny26-Sep-05 3:02

bugDanny

26-Sep-05 3:02

Perhaps try sending winword the WM_CLOSE message with SendMessage(), and send your own program the message, as well.

Hope this helps!

Danny

Font , DPI settings

Pazzuzu26-Sep-05 1:35

Pazzuzu

26-Sep-05 1:35

Hi all,

It is more of a windows question than Visualc++ related.

My questions are regarding the windows display settings.

[1]How Can I set "large","small" fonts settings under windows.Iam using WinXp & If I go to ControlPanel->Display,(Darstellung Tab,Iam using a German wINxP),I see the font->Normal,Large & Extra Large.

Is this the place for setting large & small Fonts.If yes,I see it only as Normal,Large & extraLarge under my system.

[2]
If I go to Settings->advanced Tab,I see the DPI setting combobox containing,96 dpi,120 & userdefined value. What is this setting for & How is it related to the screen resolution....

Hope someone could clear up my mind..

Thanks...

Set Time For a ToolTip before it Appears

swarnamanoo26-Sep-05 1:24

swarnamanoo

26-Sep-05 1:24

Hi all..
I want to set some time for a menu tooltip before it appears when the cursor is placed on the menu item.For eg if i place my cursor on the menu item and i do not want the tooltip to appear immediately, instead it should appear after the time which is set.
How can i do that?

Re: Set Time For a ToolTip before it Appears

FarPointer26-Sep-05 1:40

FarPointer

26-Sep-05 1:40

check it out,

void SetDelayTime( UINT nDelay );

void SetDelayTime( DWORD dwDuration, int iTime );

default time is 500ms.

best of luk
thanx

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