|
Garth J Lancaster wrote: reminder to self, must not post on CP when work hours > 14
Wow, I usually work no more than 6 hours per day 
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]
|
|
|
|
|
i m using the below code , but the result saves in another excel file.
can anyone suggest y it happens?
_Application app;
Workbooks books;
_Workbook book;
Worksheets sheets;
_Worksheet s;
Range range;
Font font;
Range cols;
LPDISPATCH lpDisp; // Often reused variable.
// Commonly used OLE variants.
COleVariant
covTrue((short)TRUE),
covFalse((short)FALSE),
covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
// Start Excel and get Application object.
if(!app.CreateDispatch("Excel.Application"))
{
AfxMessageBox("Couldn't start Excel and get Application object.");
return;
}
lpDisp = app.GetWorkbooks(); // Get an IDispatch pointer.
ASSERT(lpDisp);
books.AttachDispatch(lpDisp); // Attach the IDispatch pointer
// to the books object.
// Open a new workbook and attach that IDispatch pointer to the
// Workbook object
lpDisp = books.Add( covOptional );
ASSERT(lpDisp);
book.AttachDispatch( lpDisp );
lpDisp = books.Open("D:\\test.xls",
covOptional, covFalse, covTrue, covOptional,
covOptional, covTrue, covOptional, covOptional,
covTrue, covOptional, covOptional, covOptional,
covOptional, covOptional);
// Get the Sheets collection and attach the IDispatch pointer to your
// sheets object.
*/
/* lpDisp = book.GetSheets();
ASSERT(lpDisp);
sheets.AttachDispatch(lpDisp);
// Get *** #1 and attach the IDispatch pointer to your ***
// object.
lpDisp = sheets.GetItem( COleVariant((short)(1)) );
//GetItem(const VARIANT &index)
ASSERT(lpDisp);
s.AttachDispatch(lpDisp);
// Fill range A1 with "1/25/98", the settlement date.
lpDisp =s.GetRange(COleVariant("A1"), COleVariant("A1"));
ASSERT(lpDisp);
range.AttachDispatch(lpDisp);
range.SetValue2(COleVariant("change")); // Excel 2002 and Excel 2003
// checking for the particular cell if it's empty
VARIANT value1;
char str[]="A";
char strf[]="";
int i = 1;
char str1[10];
_itoa(i,str1,10);
strcpy(strf,str);
strcat(strf,str1);
range = s.GetRange(COleVariant(strf),COleVariant(strf));
value1 = range.GetValue2();
while(!value1.vt == VT_EMPTY)
{
i++;
_itoa(i,str1,10);
strcpy(strf,str);
strcat(strf,str1);
range = s.GetRange(COleVariant(strf),COleVariant(strf));
value1 = range.GetValue2();
}
range.SetValue2(COleVariant("Country"));
book.Save();
{
COleSafeArray saRet;
saRet.Detach();
}
app.SetVisible(TRUE);
app.SetUserControl(TRUE);
|
|
|
|
|
I can access all data from a single table.But If I want to access selected data from multiple tables then I get an error after executing.
ERROR: ORA-00903: invalid table name
DSN Name: om_ebridge.
Oracle User Name: SCOTT
Table Names: Transaction_Master,Transporter_Master,Supplier_Master,Product_Master.
CString CMyebridgeSet::GetDefaultConnect()
{
return _T("ODBC;DSN=om_ebridge");
}
CString CMyebridgeSet::GetDefaultSQL()
{
//return _T("[SCOTT].[TRANSACTION_MASTER]");(works to access data from single table.)
-------------------------
(But ERROR occurs if the below mentioned INNER JOIN is used to access selected data from multiple tables .Can you please help me access data).
return _T("SELECT TRANSACTION_MASTER.TRANSACTION_CODE,TRANSACTION_MASTER.VEHICLE_NO,TRANSACTION_MASTER.OPERATING_MODE,")
_T("TRANSPORTER_MASTER.transporter_name,SUPPLIER_MASTER.SUPPLIER_NAME,")
_T("PRODUCT_MASTER.PRODUCT_NAME,TRANSACTION_MASTER.unit,TRANSACTION_MASTER.Gross_Wt,TRANSACTION_MASTER.Gross_WtTime,")
_T("TRANSACTION_MASTER.Tare_Wt,TRANSACTION_MASTER.Tare_WtTime,TRANSACTION_MASTER.CONTAINER1_TAREWT,")
_T("TRANSACTION_MASTER.CONTAINER2_TAREWT ,TRANSACTION_MASTER.net_Wt,TRANSACTION_MASTER.Challan_no,TRANSACTION_MASTER.Challan_Wt,")
_T("TRANSACTION_MASTER.No_Of_Units,TRANSACTION_MASTER.Calculated_Wt,TRANSACTION_MASTER.Formula1,")
_T("TRANSACTION_MASTER.Formula2,TRANSACTION_MASTER.Formula3,TRANSACTION_MASTER.Formula4,")
_T(" TRANSACTION_MASTER.location_code,TRANSACTION_MASTER.field1,TRANSACTION_MASTER.field2,TRANSACTION_MASTER.field3 ")
_T("from PRODUCT_MASTER INNER JOIN SUPPLIER_MASTER INNER JOIN TRANSACTION_MASTER")
_T("ON SUPPLIER_MASTER.SUPPLIER_CODE =TRANSACTION_MASTER.SUPPLIER_CODE")
_T("ON PRODUCT_MASTER.PRODUCT_CODE=TRANSACTION_MASTER.PRODUCT_CODE")
_T("INNER JOIN TRANSPORTER_MASTER ON TRANSPORTER_MASTER.TRANSPORTER_CODE=TRANSACTION_MASTER.TRANSPORTER_CODE ");
}
|
|
|
|
|
Divya Lalwani wrote: ERROR: ORA-00903: invalid table name
So what do you not understand about this? Look at each table you are referencing. At least one of them is invalid.
"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
|
|
|
|
|
|
hi,
maybe you can override "preTh...." function of dialog's parent windows, and send message to this dialog!
|
|
|
|
|
your means is this:
BOOL CDlg::PreTranslateMessage(MSG* pMsg)
{
if (pMsg->message == WM_MOUSEMOVE)
{
SendMessage(WM_USERMOVE,0,0);
}
return CDialog::PreTranslateMessage(pMsg);
}
-------------
LRESULT CMap::OnUserMove(WPARAM wp, LPARAM lp)
{
m_tooltip.RelayEvent(pMsg);
return TRUE;
}
|
|
|
|
|
You can use the GetCurrentMessage function.
If you vote me down, my score will only get lower
|
|
|
|
|
hi,
thanku for your reply,can i do like this?
LRESULT CMap::OnUserMove(WPARAM wp, LPARAM lp)
{
MSG* pMsg = GetCur...; // is this your meanings?
m_tooltip.RelayEvent(pMsg);
return TRUE;
}
thanku again!
|
|
|
|
|
hi,
is your question how to get the information of "pMsg"?
there are two method, maybe answer your request.
1. refer to 'sendmessage' function, it can take information of msg to receiptor like that:
" sendmessage(WM_xxx, wp,lp);"
then , in function "OnusrMove(wp,lp)", you use the parameter of 'wp/lp' to do something.
2. in ' pretranslatemessage' function, call the process 'mousemove' straight.
|
|
|
|
|
hi,
thanku for your reply,but another problem again...
1.the pMsg is MSG* type,and wp or lp is DWORD type, is this can convert to each other?
2.in Pretrans...,can i do like this? -->
... ::Pretrans..(MSG* pMsg)
{
if( ... == wm_mousemove)
{
CMyChildDlg.m_tooltips.RelayEvent(pMsg); // is this ok?
}
...
}
thanks again!
|
|
|
|
|
hi,
1. read the structure of msg in detail,
typedef struct tagMSG {
HWND hwnd;
UINT message;
WPARAM wParam;
LPARAM lParam;
DWORD time;
POINT pt;
#ifdef _MAC
DWORD lPrivate;
#endif
} MSG, *PMSG, NEAR *NPMSG, FAR *LPMSG;
wp is pMsg->wPar...
lp is pMsg->lP...
2. maybe yes, i did't check this code. you try to test it.
|
|
|
|
|
hi,
1. for pMsg, there are some other params, just only send/post wp and lp can resolve the problem?
2. ok, i will test it.but cannot now.
thank u again!
|
|
|
|
|
|
I have downdload the the fantastic control named cgfxoutbarctrl,
at http://www.codeguru.com/controls/outbar.shtml[^],now I try to chang the right view of CGfxSplitterWnd(derived from CSplitterWnd).But exception occurs when
runing it and the dialog displays "Unhandled exception in filetitle.exe(MFC42D.DLL):0x0000005 Access Violation".I found the hWnd=??? in the class pointer during debug.
Fllowing is my own code ,please tell me what's wrong with it and how to correct,thanks!!
<br />
void CMySplitterWnd::ChangeView(int row, int col, CRuntimeClass* pViewClass)<br />
{<br />
ASSERT(pViewClass->IsDerivedFrom(RUNTIME_CLASS(CView)));<br />
<br />
CView* pView = STATIC_DOWNCAST(CView, GetPane(row, col));<br />
CFrameWnd* pFrame = pView->GetParentFrame();<br />
ASSERT(pFrame);<br />
<br />
CCreateContext cc;<br />
memset(&cc, 0, sizeof(cc));<br />
cc.m_pNewViewClass = pViewClass;<br />
cc.m_pCurrentDoc = pView->GetDocument();<br />
cc.m_pNewDocTemplate = cc.m_pCurrentDoc ?<br />
cc.m_pCurrentDoc->GetDocTemplate() : NULL;<br />
cc.m_pCurrentFrame = pFrame;<br />
<br />
DeleteView(row, col);
TRACE("Rows=%d,Columns=%d",GetRowCount,GetColumnCount);<br />
VERIFY(CreateView(row, col,
pViewClass,<br />
CSize(0,0),
&cc));<br />
<br />
RecalcLayout();
<br />
CWnd* pWnd = GetPane(row, col);<br />
if (pWnd)<br />
pWnd->SendMessage(WM_INITIALUPDATE);<br />
}<br />
<br />
|
|
|
|
|
Hi all,
please tell me how can i save value of COLORREF type variable in access databse.
what type of variable use for this?
please help me for this.
thanks in advance.
IN A DAY, WHEN YOU DON'T COME ACROSS ANY PROBLEMS - YOU CAN BE SURE THAT YOU ARE TRAVELLING IN A WRONG PATH
|
|
|
|
|
|
COLORREF is defined as typedef DWORD COLORREF;
-Saurabh
|
|
|
|
|
NUMBER with FieldSize = LONG INTEGER, see [^]
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]
|
|
|
|
|
how to set monitor frequency using vc++ code?
|
|
|
|
|
If you have sample of MSDN(I dont remember which version) it has an example for it when you run that example it shows to you a list(listbox) of frequencys and resolutions.
|
|
|
|
|
Hello,
I have created an MFC application and want to create a setu for it.
Kindly help me out.
Thanks In Advance.
Dhiraj
|
|
|
|
|
Hi,
You can use Install Shield.
or
You can Create one new Setup Project in Visual Studio.
The price of anything is the amount of life you exchange for it.
Thanks and Regards.
SANTHOSH V
|
|
|
|
|
use inno setup for creating setup of ur project
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
