C / C++ / MFC Discussion Boards

Re: Removing else in this statements How?

David Crow4-Jan-09 15:59

4-Jan-09 15:59

LRESULT CMainDlg::OnInstall(WORD, WORD wID, HWND, BOOL& )
{    
    string LaunchInstaller;
    string InstallFolder;
    InstallClass installclass;
    TCHAR tcItemText[MAXBYTES];
 
    if(UpdateList.GetItemText(Select, tcItemText, MAXBYTES))
    {
        InstallFolder = tcItemText;
 
        LaunchInstaller = installclass.ConstructInstallerKey(IDS_MANAGEKEY, InstallFolder);
        if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
            return 0;
 
        LaunchInstaller = installclass.ConstructInstallerKey(IDS_RERITEKEY, InstallFolder);
        if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
            return 0;
 
        LaunchInstaller = installclass.ConstructInstallerKey(IDS_RERITEASIANKEY, InstallFolder);
        if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
            return 0;
 
        LaunchInstaller = installclass.ConstructInstallerKey(IDS_RERITECHINAKEY, InstallFolder);
        if (installclass.InstallUpdate(LaunchInstaller.c_str())) 
            return 0;
    }
    else
    {
        MessageBox(_T("Please choose an item to install"), _T("Redmap Update Manager"), MB_ICONWARNING);
    }
 
    return 0;
}

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

MS‘s BUG？ why can't get value from excel?

ZhiLiangLin4-Jan-09 14:51

ZhiLiangLin

4-Jan-09 14:51

i want to get value from excel,for example:
COLUMN1 COLUMN2
----------------
123 456
ABC DEF
123 ABC
EFG HIJ

like this,i can't get '123' ,but i can get 'ABC'.
my code :
void ReadTrustListFromExcel(CString sFile)
{
CDatabase database;
CString sSql;
CString sItem1, sItem2;
CString sDriver;
CString sDsn;

sDriver = GetExcelDriver();//GetExcelDriver();
if (sDriver.IsEmpty())
{
return;
}

sDsn.Format(_T("ODBC;DRIVER={%s};DSN='';DBQ=%s"), sDriver, sFile);
TRY
{
database.Open(NULL, false, false, sDsn);
CRecordset recset(&database);

sSql.Format(_T("SELECT * FROM [%s$A1:IV65535]"),_T("EmailSheet"));

recset.Open(CRecordset::forwardOnly, sSql, CRecordset::readOnly);

while (!recset.IsEOF())
{
recset.GetFieldValue(short(0), sItem1);
recset.GetFieldValue(short(1), sItem2);
TRACE(_T("name:%s,addr:%s\r\n"),sItem1,sItem2);
recset.MoveNext();
}
database.Close();
}
CATCH(CDBException, e)
{
TRACE(_T("ERROR"));
}
END_CATCH;

Re: MS‘s BUG？ why can't get value from excel?

David Crow4-Jan-09 16:06

David Crow

4-Jan-09 16:06

ZhiLiangLin wrote:
sDsn.Format(_T("ODBC;DRIVER={%s};DSN='';DBQ=%s"), sDriver, sFile);

Is the value of sDsn correct?

ZhiLiangLin wrote:
sSql.Format(_T("SELECT * FROM [%s$A1:IV65535]"),_T("EmailSheet"));

Have you tried:

sSql.Format(_T("SELECT * FROM [%s$A1:B4]"), _T("EmailSheet"));

Does it have anything to do with those cells containing numbers? Do any of the rows read correctly?

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

Re: MS‘s BUG？ why can't get value from excel?

ZhiLiangLin4-Jan-09 18:21

ZhiLiangLin

4-Jan-09 18:21

the api 'getfieldvalue' can't get the value.

Re: MS‘s BUG？ why can't get value from excel?

David Crow5-Jan-09 3:56

David Crow

5-Jan-09 3:56

So have you used the debugger to step into that method to find out why?

"Love people and use things, not love things and use people." - Unknown

"The brick walls are there for a reason...to stop the people who don't want it badly enough." - Randy Pausch

Just-In-Time Debugger

Larry Mills Sr4-Jan-09 14:51

Larry Mills Sr

4-Jan-09 14:51

I had to re-install VS2008 when I re-installed the operating system. Somehow the "Just-In-Time Debugger" de not get installed. I tried going to Microsoft downloads for it and all they offer is VS20088 SP1. Every time I installed VS2008 SP1 it messed VS2008 up so I won't install it. Does anyone know how I can get a copy of the "Just-In-Time Debugger" from microsoft?(Microsoft Script Debugger is another name for it).

A C++ programming language novice, but striving to learn

Re: Just-In-Time Debugger

ThatsAlok5-Jan-09 0:24

ThatsAlok

5-Jan-09 0:24

microsoft bug team Smile | :)

will surly reply you back on this issue!

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture

cheers,
Alok Gupta
VC Forum Q&A :- I/IV
Support CRY- Child Relief and You

Adobe GIL - any experience to share?

islobodan4-Jan-09 13:05

islobodan

4-Jan-09 13:05

Anyone have any experience and thoughts to share about Adobe GIL
GIL[^]

I'm considering GIL library as replacement for GDI+ for my ongoing project.

Thanks

How to make the cursor move to the next ctrol of EDIT automatic?

titan_sky_king4-Jan-09 12:55

titan_sky_king

4-Jan-09 12:55

I have a DIALOG project with more than fifty EDIT.I want to make the cursor move to the next EDIT when the length of each EDIT get five.

But I don't know how to realize it.Please help me!

Thanks!

Re: How to make the cursor move to the next ctrol of EDIT automatic?

Richard Andrew x644-Jan-09 14:08

Richard Andrew x64

4-Jan-09 14:08

You could handle the KeyPress event and call GetWindowText on the edit control to count how many chars have been entered.

Then, when 5 chars have been entered, call SetFocus on the next edit control to move the cursor there.

Re: How to make the cursor move to the next ctrol of EDIT automatic?

titan_sky_king5-Jan-09 17:45

titan_sky_king

5-Jan-09 17:45

Thanks very much!

Re: How to make the cursor move to the next ctrol of EDIT automatic?

Mark Salsbery4-Jan-09 15:17

Mark Salsbery

4-Jan-09 15:17

I'd go with Richard's reply, except instead of SetFocus, I'd use
the WM_NEXTDLGCTL message. WM_NEXTDLGCTL automatically selects the
edit control text so the user can just type if there's existing text.

Of course, if the edit control is empty it does't make a difference Smile | :)

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: How to make the cursor move to the next ctrol of EDIT automatic?

titan_sky_king5-Jan-09 17:46

titan_sky_king

5-Jan-09 17:46

Thank you very much!

Menus

BobInNJ4-Jan-09 5:59

BobInNJ

4-Jan-09 5:59

I am developing a GUI based application using C++ and MFC. I have a couple of menu options
that should be grayed out when the application starts up. What I mean by grayed out is that
they are not valid for the user to select and the visual appearance of the menu option should
reflect that. The menu is defined in an RC (resource script) file. What is the best way to
have these menu selections grayed out?

Thanks

Bob

Re: Menus

Mark Salsbery4-Jan-09 6:38

Mark Salsbery

4-Jan-09 6:38

Typically, the ON_UPDATE_COMMAND_UI Macro[^] is used to provide a command enabler function.

Mark

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: Menus

BobInNJ4-Jan-09 11:38

BobInNJ

4-Jan-09 11:38

Mark or anybody else that knows,

Thanks for the response. However, I am not sure what you are saying. Please consider
the following menu:

Selection 1
   Selection a
   Selection b
   Selection c
   Selection d

and the user chose Selection 1, I use then have a function (or method) to gray out
the sub-menu selection that I wanted grayed out. If so, how would the handler do
that?

I was thinking that I might do it when the menu is first created. I world do this by using the macro ON_WM_INITMENUPOPUP. What do you think of my approach?

Bob

Re: Menus

Richard Andrew x644-Jan-09 12:17

Richard Andrew x64

4-Jan-09 12:17

You can set the menu status with this function call:

CMenu::SetMenuItemInfo

Re: Menus

Mark Salsbery4-Jan-09 15:10

Mark Salsbery

4-Jan-09 15:10

BobInNJ wrote:
I am not sure what you are saying

I'm saying typically Selection a, Selection b, etc. each have an associated command
(for example, using the wizards, ID_SELECTION1_SELECTIONA)

// menu resource

IDR_MYMENU MENU 
BEGIN
    POPUP "Selection 1"
    BEGIN
        MENUITEM "Selection a",                 ID_SELECTION1_SELECTIONA
        MENUITEM "Selection  b",                ID_SELECTION1_SELECTIONB
    END
END



// added to message map of menu's window class
    ON_UPDATE_COMMAND_UI(ID_SELECTION1_SELECTIONA, &CMainFrame::OnUpdateSelection1Selectiona)
...
// added to menu's window class
void CMyMenuWindowFrame::OnUpdateSelection1Selectiona(CCmdUI *pCmdUI)
{
    if (some_state)
        pCmdUI->Enable(TRUE);
    else
        pCmdUI->Enable(FALSE);
}

Three advantages of using the command macros are:
1) MFC does the work for you
2) The IDE has wizards to add the command handler and enabler functions with just clicks
3) If you have a toolbar or possibly other context menu(s) with equivalent
commands, you only have to write the enabling code in one place.

That's the MFC way.....you are free to do it manually if you want to.

Mark Salsbery
Microsoft MVP - Visual C++
Java | [Coffee]

Re: Menus

BobInNJ5-Jan-09 12:08

BobInNJ

5-Jan-09 12:08

Mark,

Thanks for the detailed response. It solved my problem.

Bob

CBrush - color

korte254-Jan-09 5:11

korte25

4-Jan-09 5:11

Hi! I have a CBrush created with the CBrush(COLORREF crColor) constructor. I'd like to know if I can retrieve this colorref later from the CBrush, or do I have to store it in a variable? Thx

Re: CBrush - color

CPallini4-Jan-09 5:20

CPallini

4-Jan-09 5:20

This method [^] looks promising (see the lbColor member of the LOGBRUSH [^] struct).
Smile | :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

Re: CBrush - color

korte254-Jan-09 5:41

korte25

4-Jan-09 5:41

Thanks a lot

Re: CBrush - color

CPallini4-Jan-09 5:42

CPallini

4-Jan-09 5:42

You're welcome.
Smile | :)

Webbrowser control + ActiveX

nobaq4-Jan-09 3:39

nobaq

4-Jan-09 3:39

Hi,

Is it possible to enable/allow ActiveX controls inside my webbrowser control (CHtmlView).

Please do not say it is not possible! Frown | :-(

Niki

PS: Background: I'm writing a database application where data is stored in html format. There are also popups (similar to the old WinHelp32) which are implemented using JavaScript (or similar things; these scripts are not written by me). When I open such a HTML file directly in IE I get the security warning (even when all files are local). In my webbrowser control I even do not get a warning but only script errors.

Re: Webbrowser control + ActiveX

nobaq4-Jan-09 4:10

nobaq

4-Jan-09 4:10

I have found CoInternetSetFeatureEnabled.

But nothing changes Frown | :-(

I have already set FEATURE_WEBOC_POPUPMANAGEMENT, FEATURE_SECURITYBAND, FEATURE_LOCALMACHINE_LOCKDOWN, FEATURE_RESTRICT_ACTIVEXINSTALL. But nothing changes Frown | :(

I again get a script error with "Permission denied" Frown | :(

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