C / C++ / MFC

Re: Problem with LIKE from MFC

8-Apr-02 19:35

What does strSql contain after the format statement? I suspect from the example you gave that you'll be missing a percentage and quote sign. This is because the two characters "%'" will be removed from your string. To get a '%' character in a string you need to put two of them (%%):

strSql.Format("SELECT COUNT([TblCatalogList].[CatalogId]) FROM [TblCatalogList] WHERE [TblCatalogList].[PcBoard] LIKE '%s%%'",strBoard);

Hope this helps.

------------------------
Derek Waters
derek@lj-oz.com

Lakitu8-Apr-02 23:27

Lakitu

8-Apr-02 23:27

To get a literal % sign you'll need to specify it as %% in the format string.

You know, for kids!

Enable/Disable Toolbar *Buttons* :: MFC

valikac8-Apr-02 19:18

8-Apr-02 19:18

Hi.

I would like to enable and disable one or more toolbar *buttons*. According to what Prosise mentioned, it can be done using the Enable() that the framework passes to a menu/toolbar update message handler. However, I am not quite clear on how to disable a specific toolbar button. For example, let say I have a toolbar with five buttons.

[button1][button2][button3][button4][button5]

How would I enable/disable, say, button2?

Thanks,
Kuphryn

Derek Waters8-Apr-02 19:31

8-Apr-02 19:31

When you create each button in the toolbar, it should have an associated command ID. These IDs are passed in as an array in the CToolBar::SetButtons() command. If you create a toolbar in the resource editor (this is from memory, I don't normally do it this way) I think you just select one of the buttons on your toolbar and bring up the properties, then add a command ID there.

Anyway, this ID is the command ID used in the ON_UPDATE_COMMAND_UI update handler (ie you have one handler per toolbar button, not for the toolbar as a whole). If you have a range of toolbar buttons and you don't want to write code for all of them, you can also use ON_UPDATE_COMMAND_UI_RANGE.

So, in summary, each Update Command handler should apply to a single toolbar button.

------------------------
Derek Waters
derek@lj-oz.com

valikac8-Apr-02 19:42

8-Apr-02 19:42

Okay. Thanks.

I am uncertain one something. Here is what I am trying to do. When the application first starts, I want to disable one or more buttons. When the user select a certain option via menu, then the program would enable the button. I need a way to get a hold of a pointer to the toolbar right when the application starts up so I can disable one or more buttons. It can be done with commandUI and commandUI_RANGE, but how about any other arbitrary time?

Kuphryn

Derek Waters8-Apr-02 19:49

8-Apr-02 19:49

Well, you can put your command handler anywhere that message are received. The best place to put them in this case would probably be the CFrameWnd-derived class where you create the toolbar. The same class would also have a handler for the menu item. For example, if the menu item is ID_ALLOW_BUTTON and the button itself is ID_MY_BUTTON:

In the header:

bool   m_bButtonAllowed;

afx_msg void OnAllowButtonMenu();
afx_msg void OnUpdateMyButton(CCmdUI *pCmdUI);
afx_msg void OnMyButton();

In your constructor:

m_bButtonAllowed = false;

In the message map:

ON_COMMAND(ID_ALLOW_BUTTON, OnAllowButtonMenu)
ON_UPDATE_COMMAND_UI(ID_MY_BUTTON, OnUpdateMyButton)
ON_COMMAND(ID_MY_BUTTON, OnMyButton)

Then:

CMainFrame::OnAllowButtonMenu()
{
  m_bButtonAllowed = true;
}

CMainFrame::OnUpdateMyButton(CCmdUI *pCmdUI)
{
  pCmdUI->Enable(m_bButtonAllowed ? 1 : 0);
}

CMainFrame::OnMyButton()
{
  AfxMessageBox("Got me!");
}

Hope this helps.

------------------------
Derek Waters
derek@lj-oz.com

valikac8-Apr-02 20:14

8-Apr-02 20:14

Thanks. That is exactly what I thought of.

Just one more thing: should I map the command UI update in the MainFrm or the view? I am working with doc/view architecture.

Kuphryn

Derek Waters8-Apr-02 20:22

8-Apr-02 20:22

Aaah, that old chestnut! It really depends on what the toolbar button does. If the operation of the button could apply to more than one view type (for example, the program I'm working on has ten doc/view types, and some buttons apply to all, while others apply to only one) then it probably makes more sense to put it in MainFrame. If the button only really applies to one view type, it's probably going to be easier to update in the view, otherwise you're going to need to do something like:

void CMainFrame::MyUpdateHandle(CCMdUI *pCmdUI)
{
  pCmdUI->Enable(FALSE);
  CFrameWnd *vpFrame = GetActiveFrame();
  if (vpFrame != NULL)
  {
    CView *vpView = vpFrame->GetActiveView();
    if (vpView != NULL)
    {
      if (vpView->IsKindOf(RUNTIME_CLASS(CMyButtonView)))
      {
        CMyButtonView *vpMyView = static_cast<CMyButtonView *>vpView;
        if (vpMyView->ShouldIEnableTheButton())
        {
          pCmdUI->Enable(TRUE);
        }
      }
    }
  }
}

Whew! As opposed to:

CMyButtonView::OnUpdateButton(CCmdUI *pCmdUI)
{
  pCmdUI->Enable(ShouldIEnableTheButton());
}

So, all in all, it's really a style/ease of programming kind of question. I'll leave that decision up to you...

Hope this helps.

------------------------
Derek Waters
derek@lj-oz.com

valikac8-Apr-02 20:28