|
Aniket Salunkhe wrote:
SELECT A.RegNo, A.Name, Format(C.CcOrderDate,'dd-MMM-yyyy'), C.CcOrderPeriod, Format(DateAdd('m',C.CcOrderPeriod,C.CcOrderDate),'dd-MMM-yyyy') FROM Table1 AS A, Table2 AS C;
Will this work:
SELECT A.RegNo, A.Name, Format(C.CcOrderDate,'dd-MMM-yyyy') AS _date, C.CcOrderPeriod, Format(DateAdd('m',C.CcOrderPeriod,C.CcOrderDate) AS _period,'dd-MMM-yyyy') FROM Table1 AS A, Table2 AS C;
...
m_Rs.GetFieldValue(_T("_date"), CellValue);
m_Rs.GetFieldValue(_T("_period"), CellValue);
"Love people and use things, not love things and use people." - Unknown
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
Hi,
I tried it. But it's also not working.
I chage
Format(DateAdd('m',C.CcOrderPeriod,C.CcOrderDate) AS _period,'dd-MMM-yyyy')
to
Format(DateAdd('m',C.CcOrderPeriod,C.CcOrderDate),'dd-MMM-yyyy') AS _period
But still it was not working.
Because when we use AS [Column Name], it's just a text to display the Column Title, but not Column Name.
So how to set Column Name in query?
Thanks & Regards,
Aniket A. Salunkhe
|
|
|
|
|
Hi i derived property sheet from Cproperty sheet
psheet is pointer to my derived class
CNSEditVirtualCircuitDlg* pSheet
and i need to assign psheet to m_pPropertySheet which is pointer to CNSProperty sheet which is derived form Cresizable sheet
i want to assign like this
m_pPropertySheet = pSheet
how to type cast m_pPropertySheet to CProperty sheet
|
|
|
|
|
Member 4655685 wrote: m_pPropertySheet = pSheet
could you please tell me , how two pointers are related, as what I make sense from it, both are following different hirechy
"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/xml>
|
|
|
|
|
m_pPropertySheet is derived from CResizable sheet
Psheet is derived from CProperty sheet
but i need to relate is it possible
|
|
|
|
|
My application crashes if I run it in release mode but when it try to debug in release mode it works fine. What could be the problem?
|
|
|
|
|
Enable debug information in the release build and debug it.
Steve
|
|
|
|
|
Please read this.
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]
|
|
|
|
|
CPallini wrote: Please read this.
Godly guide for Release version survival!
"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/xml>
|
|
|
|
|
There are 3 tabs in my application. On opening the application the 3rd tab will be in focus. When i try to resize the tabwindow, 3rd will be in focus but the contents of 2nd tab will be displayed. After switching between the tabs the tabs will get refreshed. How do I solve this refresh problem?
|
|
|
|
|
How are you setting the default tab to the third tab at startup?
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
|
TCM_SETCURSEL does NOT cause a TCN_SELCHANGE message to be sent, so when you use
SetCurSel(), you are responsible for making sure the correct tab window is
positioned and shown within the tab's "client area".
Mark
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
So, how do I solve this refresh problem now?
|
|
|
|
|
A couple of weeks ago I enabled XP's automatic updates (it hadn't been upgraded since I installed XP SP1 a year ago). After the upgrade (XP SP2 and it also did some secuirty upgrade to my VS2005) I cannot build any of my code anymore. At first I got a bunch of errors, then I retarted my machine, at which point there was an error message on boot up that I've never seen before, immediately followed by an "automated" fix. Now when I try to recompile again it still doesn't work, but the errors are different.
------ Rebuild All started: Project: NSMAnalysis, Configuration: Release Win32 ------
Deleting intermediate and output files for project 'NSMAnalysis', configuration 'Release|Win32'
Compiling...
stdafx.cpp
C:\Program Files\Microsoft Visual Studio 8\VC\atlmfc\include\afxwin.h(2613) : error C2061: syntax error : identifier 'HDROP'
C:\Program Files\Microsoft Visual Studio 8\VC\atlmfc\include\afxwin.h(3621) : error C2061: syntax error : identifier 'HDROP'
C:\Program Files\Microsoft Visual Studio 8\VC\atlmfc\include\afxwin2.inl(70) : error C2039: 'DragAcceptFiles' : is not a member of '`global namespace''
C:\Program Files\Microsoft Visual Studio 8\VC\atlmfc\include\afxwin2.inl(70) : error C2660: 'CWnd::DragAcceptFiles' : function does not take 2 arguments
C:\Program Files\Microsoft Visual Studio 8\VC\atlmfc\include\afxwin2.inl(423) : error C2065: 'HDROP' : undeclared identifier
C:\Program Files\Microsoft Visual Studio 8\VC\atlmfc\include\afxwin2.inl(424) : error C2448: 'CWnd::OnDropFiles' : function-style initializer appears to be a function definition
I can't find where HDROP is defined but the error concerning DragAcceptFiles is strange. afxwin2.inl calls this function with 2 arguments but it's defined in afxwin.h with only one. How is this possible? Were the header files changed during the updates?? If they weren't how did it EVER work?
Thanks.
Mike
|
|
|
|
|
|
May be You have to reinstall VS2005 again.
|
|
|
|
|
How do I delete the pop up menu created by default in the CEdit class?
|
|
|
|
|
Sunayna wrote: the pop up menu created by default in the CEdit class?
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]
|
|
|
|
|
|
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]
|
|
|
|
|
Have you searched CP for "CEdit context menu"?
|
|
|
|
|
Sunayna wrote: How do I delete the pop up menu created by default in the CEdit class?
you have to derive the class from the CEdit and handle the WM_LBUTTONDOWN message and plant your new popup menu there!
"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/xml>
|
|
|
|
|
ThatsAlok andle the WM_LBUTTONDOWN message
Is it right??
Regards,
Sandip.
|
|
|
|
|
There is a MDIchild window which has the CEdit class. Initially page up and page down keys were working.On setting the virtual key codes for page up and page down, page up and page down is not working. How do I enable the functionality of Page up and page down
|
|
|
|
|
What is bad in handling the OnKeyDown/OnKeyUp and calling the scroll if pressed key is PageUp/Down??
Regards.
--------
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
“The First Rule of Program Optimization: Don't do it. The Second Rule of Program Optimization (for experts only!): Don't do it yet.” - Michael A. Jackson
Rating helpfull answers is nice, but saying thanks can be even nicer.
|
|
|
|