C / C++ / MFC Discussion Boards

Re: Date

Cool_Dev1-Sep-10 2:45

Cool_Dev

1-Sep-10 2:45

what is the format of time you are having? If in MFC its easy to use CTime and CTimeSpan classes.

psuedo code:

CTime curTime(...);
CTimeSpan span(7/*Days*/, 0,...);

Ctime newTime = curTime - span;

Re: Date

Bijo Pulikkottil1-Sep-10 3:20

Bijo Pulikkottil

1-Sep-10 3:20

Plz tell me how to do that?
If I want to get date before 7 days from current date?

How to do that?

Re: Date

Cedric Moonen1-Sep-10 3:22

Cedric Moonen

1-Sep-10 3:22

Wow, you really need glasses because he even provided a code snippet showing exactly how to do it...

Cédric Moonen
Software developer

Charting control [v3.0]
OpenGL game tutorial in C++

Re: Date

David Crow1-Sep-10 4:30

David Crow

1-Sep-10 4:30

Bijo Pulikkottil wrote:
If I have today date.

Based on what? Is it a CTime object? Is it a time_t variable? If you have the number of seconds since some epoch, can't you just subtract 86400 * 7 seconds?

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"Man who follows car will be exhausted." - Confucius

Error :: 0x800706F7 "the stub received bad data" in Excel Automation.

Le@rner1-Sep-10 1:07

Le@rner

1-Sep-10 1:07

Hi all,

i m using to Excel automation to read and write excel files.

i write excel file like this.

CoInitialize(NULL);
{
    Excel::_ApplicationPtr XL;
    HRESULT hr;
    try
    {
        XL.CreateInstance(L"Excel.Application");

        // create workbook & worksheet
        // identify range to which array will be assigned

        _variant_t var((long)DISP_E_PARAMNOTFOUND,VT_ERROR);

        XL->Workbooks->Add(Excel::xlWorksheet);
        Excel::_WorksheetPtr pSheet = XL->ActiveSheet;

        Excel::RangePtr pRange = pSheet->Cells;//on this line error is occur

        Excel::RangePtr pBeginRange = pRange->Item[1][1];
        Excel::RangePtr pEndRange = pRange->Item[1][1];
        Excel::RangePtr pTotalRange = pSheet->Range[(Excel::Range*)pBeginRange][(Excel::Range*)pEndRange];

        // create some BSTRs
        wchar_t wsz1[] = L"C";
        wchar_t wsz2[] = L"D";
        BSTR bstr1;
        bstr1 = SysAllocString(wsz1);

        BSTR bstr2;
        bstr2 = SysAllocString(wsz2);

        // create safearray
        SAFEARRAYBOUND rgsabound[2] = { 0 };
        rgsabound[0].cElements = 1; // num rows
        rgsabound[0].lLbound = 0; // lower bound
        rgsabound[1].cElements = 1; // num cols
        rgsabound[1].lLbound = 0; // lower bound

        VARIANT arr;
        arr.vt = VT_ARRAY | VT_BSTR;
        arr.parray = SafeArrayCreate(VT_BSTR,2,rgsabound);
        // identify index we want to change
        long index[2];
        // modify first element <0,0>
        index[0] = 0;
        index[1] = 0;
        hr = SafeArrayPutElement(arr.parray,index,bstr1);


        // assign safearray to range
        pTotalRange->PutValue2(&arr);
        // cleanup
        VariantClear(&arr);
        SysFreeString(bstr1);
        SysFreeString(bstr2);

        XL->Visible = true;

    }
    catch(_com_error &error)
    {
        cout << "COM error " << endl;
    }
}
CoUninitialize();

when i write excel file i received this error

0x800706F7 

"the stub received bad data"

please tell me how can i solve it.

thanks in advance.

Re: Error :: 0x800706F7 "the stub received bad data" in Excel Automation.

Cool_Dev1-Sep-10 2:37

Cool_Dev

1-Sep-10 2:37

if you have #imported the correct dlls and olbs for the installed version of Excel, everything seems fine.

Re: Error :: 0x800706F7 "the stub received bad data" in Excel Automation.

Le@rner2-Sep-10 0:23

Le@rner

2-Sep-10 0:23

This happens when i run application on Office 2010 Beta version.while i run application on office 2007 its working fine.

Cannot create DSN name

raju_shiva1-Sep-10 0:49

raju_shiva

1-Sep-10 0:49

Hi sir,
I want to create a DSN Name and set a path for that.
I am using "SQLConfigDataSource" function for this.

It is not giving any error and running properly.But it is not writing to DNS.

Here ia wat i am doing

SQLConfigDataSource(NULL, ODBC_ADD_SYS_DSN, _T("Microsoft Access Driver (*.mdb)\0"), _T("DSN=SAMPLEE\0DBQ=D:\\SAMPLE.mdb\0"));

Am i doing right???or any other stuff need to be done.

Thanks
Raj

Re: Cannot create DSN name

CPallini1-Sep-10 2:09

CPallini

1-Sep-10 2:09

Did you check the return value?
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: Cannot create DSN name

raju_shiva1-Sep-10 18:10

raju_shiva

1-Sep-10 18:10

Hi,
I tried with this

bool aDSNCreated = false;
aDSNCreated = SQLConfigDataSource(NULL, ODBC_ADD_SYS_DSN, _T("Microsoft Access Driver (*.mdb)\0"), _T("DSN=SAMPLEE\0DBQ=D:\\SAMPLE.mdb\0")); 
printf("%d",aDSNCreated );

aDSNCreated value is zero.

what i am doing wrong??

Thanks
Raj

Re: Cannot create DSN name

CPallini1-Sep-10 21:21

CPallini

1-Sep-10 21:21

From MSDN[^]:

When SQLConfigDataSource returns FALSE, an associated *pfErrorCode value can be obtained by calling SQLInstallerError. The following table lists the *pfErrorCode values that can be returned by SQLInstallerError and explains each one in the context of this function.

Re: Cannot create DSN name

raju_shiva2-Sep-10 0:11

raju_shiva

2-Sep-10 0:11

Hi sir.

CPallini wrote:
an associated *pfErrorCode value can be obtained by calling SQLInstallerError

I am not getting how to get the errorcode.I am trying as below

bool aDSNCreated = false;
//char *str;// = "asdasdsd\0";	
RETCODE retcode= SQL_SUCCESS;
aDSNCreated = SQLConfigDataSource(NULL, ODBC_ADD_SYS_DSN, _T("Microsoft Access Driver (*.mdb)\0"), _T("DSN=SAMPLEE\0DBQ=D:\\SAMPLE.mdb\0")); 
printf("%d",aDSNCreated );
if(aDSNCreated == false)
{
	retcode = SQLInstallerError(2, NULL,NULL,100,NULL);
         
}

I am not getting wat paramaters to send and return the error code..

please help me out.

Sorry i know its a very silly question.

Thanks
Raj

Re: Cannot create DSN name

CPallini2-Sep-10 0:38

CPallini

2-Sep-10 0:38

I would do:

BOOL isDSNCreated;
isDSNCreated = SQLConfigDataSource(NULL, ODBC_ADD_SYS_DSN, _T("Microsoft Access Driver (*.mdb)\0"), _T("DSN=SAMPLEE\0DBQ=D:\\SAMPLE.mdb\0"));
if (isDSNCreated == FALSE)
{
  CHAR szError[SQL_MAX_MESSAGE_LENGTH];
  DWORD dwError;
  WORD cbError;
  RETCODE retcode;
  retcode = SQLInstallerError(1, &dwError, szError, SQL_MAX_MESSAGE_LENGTH-1, &cbError);
  // check 'retcode', have a look at 'dwError', show 'szError', whatever...
}

Re: Cannot create DSN name

raju_shiva2-Sep-10 1:45

raju_shiva

2-Sep-10 1:45

CPallini wrote:
retcode = SQLInstallerError(1, &dwError, szError, SQL_MAX_MESSAGE_LENGTH-1, &cbError);

Hi sir,
I am getting this error:

Error	47	error C2664: 'SQLInstallerErrorW' : cannot convert parameter 3 from 'CHAR [512]' to 'LPWSTR'

Thanks
Raj

Re: Cannot create DSN name

CPallini2-Sep-10 2:11

CPallini

2-Sep-10 2:11

The use:

  <big>TCHAR</big> szError[SQL_MAX_MESSAGE_LENGTH];
  DWORD dwError;
  WORD cbError;
  RETCODE retcode;
  retcode = SQLInstallerError(1, &dwError, szError, SQL_MAX_MESSAGE_LENGTH-1, &cbError);
<small>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.<br>
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. 
                -- Iain Clarke
<br></small><small><a href="http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=1778670">[My articles]</a></small>

Re: Cannot create DSN name

raju_shiva2-Sep-10 19:00

raju_shiva

2-Sep-10 19:00

Hi sir,
Thank you.Its building without error.
I am getting the retcode as zero(i.e SQL_SUCCESS).
But i am not finding the DSN Created when i am checking through Control Panel->ODBC

Thanks
Raj

Store a point within rect

mesajflaviu1-Sep-10 0:37

mesajflaviu

1-Sep-10 0:37

How can I store an position of point ( point of end/begin of an line ) which is within an rect ?

void CSelectTool::OnLButtonDown(CNetMapView* pView, UINT nFlags, const CPoint& point)
{
	CRect rect = m_Tracker.m_rect;
	// if an line is within rect then store their point into ptLine
	...
	CPoint ptLine;
	if(rect.PtInRect(rectLine.TopLeft()))ptLine = rectLine.TopLeft();
	if(rect.PtInRect(rectLine.BottomRight()))ptLine = rectLine.BottomRight();
	...
}

now I need ptLine value in follow event :

void CSelectTool::OnMouseMove(CNetMapView* pView, UINT nFlags, const CPoint& point)
{
	CRect rect = m_Tracker.m_rect;
	// rect was moved , but I want to move ptLine in  the update position
	// what is new value of ptLine ?
}

Re: Store a point within rect

CPallini1-Sep-10 0:48

CPallini

1-Sep-10 0:48

If I got you then you have to move the line of the same amount of the rectangle. i.e.

Store the original position of the rectangle.
On mouse move, subtract to current rectangle position the stored one, to obtain the offset.
add the offset to the line.

typdef struct MFC [modified]

mesajflaviu31-Aug-10 20:45

mesajflaviu

31-Aug-10 20:45

Can you tell me how to insert / acces an struct elements from another class then declare it ?

//CMyView.h

...
...
typedef struct tagLine{
	CDrawObj* pObj;
	UINT nHandle;
	CPoint point;
}Line;
...
...

	CList<<Line,Line>> m_line;
...

//CSelectTool.cpp

void CSelectTool::OnLButtonDown(CMyView* pView, UINT nFlags, const CPoint& point)
{
	// pObj is an valid pointer of custom object
	// I don't know how to insert new element !?
	pView->m_line.AddTail(pView->Line(pObj,1,point));	// this is error
}

void CSelectTool::OnMouseMove(CMyView* pView, UINT nFlags, const CPoint& point)
{
	// I don't know how to access element of pView->m_line;
}

Can you help me please ? Thank you !!!

modified on Wednesday, September 1, 2010 2:51 AM

Re: typdef struct MFC

Eugen Podsypalnikov31-Aug-10 21:02

Eugen Podsypalnikov

31-Aug-10 21:02

Try something like following Smile | :)

...
typedef struct tagLine {
  int m_i1, m_i2;
  Line(int i1, i2) : m_i1(i1), m_i2(i2) {};
} Line;
...

void CMyView::AddNewLine(int i1, int i2)
{
  m_Line.AddTail(new Line(i1, i2));
}

virtual void BeHappy() = 0;

Re: typdef struct MFC

mesajflaviu31-Aug-10 21:15

mesajflaviu

31-Aug-10 21:15

Ok , and when I want to acces an element of m_Line ?

Re: typdef struct MFC

CPallini31-Aug-10 21:26

CPallini

31-Aug-10 21:26

MSDN has a code sample [^] about accessing elements of a CList.
Smile | :)

Re: typdef struct MFC

Cedric Moonen31-Aug-10 21:02

Cedric Moonen

31-Aug-10 21:02

mesajflaviu wrote:
pView->m_line.AddTail(pView->Line(pObj,1,point)); // this is error

If your structure is defined globally (not inside your class), then you can simply do something like this (given that the structure has the appropriate constructor and your m_line variable is public):

pView->m_line.AddTail(Line(pObj,1,point));

However, it is always better to make your variables private and provide a AddLine to your CMyView instead.

mesajflaviu wrote:
// I don't know how to access element of pView->m_line;

The same way you wrote it. But once again, providing a getter is much more clean.
If you want to access a specific line in your list, then you have to use the methods from the list to retrieve the line you are looking for.

Cédric Moonen
Software developer

Charting control [v3.0]
OpenGL game tutorial in C++

Re: typdef struct MFC

mesajflaviu31-Aug-10 22:53

mesajflaviu

31-Aug-10 22:53

Here is my trial :

//	CMyView.h

typedef struct tagLine{
	CDrawObj* pObj;
	UINT nHandle;
	CPoint point;
}Line;

...
...
	CList<Line,Line> m_line;

//	CMyView.cpp

void CMyView::AddLineStruct(CDrawObj* pObj, UINT nHandle, CPoint point)
{
	Line LineStruct;
	LineStruct.pObj = pObj;
	LineStruct.nHandle = nHandle;
	LineStruct.point = point;
	m_line.AddTail(LineStruct);
}

//	CSelectTool.cpp

void CSelectTool::OnLButtonDown(CNetMapView* pView, UINT nFlags, const CPoint& point)
{
...
	pView->AddLineStruct(pObjLine,nHandle,point);
...
}

void CSelectTool::OnMouseMove(CNetMapView* pView, UINT nFlags, const CPoint& point)
{
	// here I try access elements of pView->m_line
	POSITION pos = pView->m_line.GetHeadPosition();
	while(pos != NULL)
	{
		pView->Line data = pView->m_line.GetNext(pos); // here is an error :
		//	error C2273: 'function-style cast' : illegal as right side of '->' operator
		// error C2146: syntax error : missing ';' before identifier 'data'
	}

}

still , I don't know how to acces elemts of the structure ....

Re: typdef struct MFC

mesajflaviu31-Aug-10 22:59

mesajflaviu

31-Aug-10 22:59

Perhaps will go if I declare Line strucure as global , but I didn;t want to do that ... is not elegant Frown | :(

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