Re: Different versions of ODBC drivers accept different parameters (Execute())?? - C / C++ / MFC Discussion Boards

r i s h a b h s19-Dec-02 0:47

19-Dec-02 0:47

fredrik sorry to bother u but plz. tell me where do i put
the windowproc function (In the Cwnd derived class or CDialog derived class).

Re: tray icon problem

Fredrik Skog19-Dec-02 0:50

Fredrik Skog

19-Dec-02 0:50

Use the Class Wizard to subclass the WindowProc of your dialog.

Cheers,
Fredrik

"Felix qui potuit rerum cognoscere causas."

Re: tray icon problem

r i s h a b h s19-Dec-02 1:22

r i s h a b h s

19-Dec-02 1:22

THANX FREDRIK! that worked fine.

but whenever i dblclick on the icon a new dialog box ois opened. How to make sure that only one dialog is opened at a time.

rishabhs

Re: tray icon problem

Fredrik Skog19-Dec-02 1:24

Fredrik Skog

19-Dec-02 1:24

It would help if you posted some code.

Cheers,
Fredrik

"Felix qui potuit rerum cognoscere causas."

Listing network paths?

scy7he18-Dec-02 23:08

scy7he

18-Dec-02 23:08

How can i list network paths? Something like what the command dir does is what i want.

Re: Listing network paths?

Andreas Saurwein19-Dec-02 1:22

Andreas Saurwein

19-Dec-02 1:22

Have a look at the FindFile API for the dir functionality, the network part is a bit trickier (and depends on what you want to do).

I don't think this is a serious possesion, and the evil most likely comes from your hand. Colin J Davies, The Lounge

Different versions of ODBC drivers accept different parameters (Execute())??

Wenrich18-Dec-02 22:29

Wenrich

18-Dec-02 22:29

in my app, i have the following code run successfully with
MS Access Driver 4.00.6019.00, but fail with version
4.00.6200.00. the exception thrown says
"[ODBC MS Access Driver] Too few parameters. Expected 1."

// _ConnectionPtr m_pConnection;
// _RecordsetPtr m_pRecordSet;
m_pRecordSet = m_pConnection->Execute(_bstr_t(query), &vRecsAffected, adOptionUnspecified);

How should i overcome this problem? is there a generic way
that works with different versions of MS Access Driver?

Thanks a lot!

Wenrich

Re: Different versions of ODBC drivers accept different parameters (Execute())??

Pavel Klocek18-Dec-02 22:47

Pavel Klocek

18-Dec-02 22:47

What is in query?
Maybe some field name is equal to a reserved word added in new version?

Pavel
Sonork 100.15206

Re: Different versions of ODBC drivers accept different parameters (Execute())??

Wenrich19-Dec-02 13:42

Wenrich

19-Dec-02 13:42

Thanks Varel!
this query is

CString query;
query.Format(_T("SELECT * FROM %s WHERE (%s='%s') AND (%s='%s')"), table, key, value1, field, value2);
// table:"client", key:"ID", value1:"some name", field:"Pass", values"some
// password"

Is there anything wrong with the field names?

Thanks a lot!

Re: Different versions of ODBC drivers accept different parameters (Execute())??

Pavel Klocek20-Dec-02 0:35

Pavel Klocek

20-Dec-02 0:35

I would try:

SELECT * FROM [%s] WHERE ([%s]='%s') AND ([%s]='%s')

Doesn't some of the values contain an ' character (apostrof)?

Pavel
Sonork 100.15206

Handle of a Bitmap Image ?

ArunKGoyal18-Dec-02 22:26

ArunKGoyal

18-Dec-02 22:26

How do I get the Handle of a Bitmap image which is created in bitmap resource editor.

Re: Handle of a Bitmap Image ?

PDStone18-Dec-02 22:34

PDStone

18-Dec-02 22:34

CBitmap bBitmap;
bBitmap.LoadBitmap(RESOURCE_ID);
HBITMAP hBitHandle = (HBITMAP)bBitmap;

Bear in mind when the CBitmap goes out of scope the handle will be invalid;
You may need to make the CBitmap a member Variable

Re: Handle of a Bitmap Image ?

Dominik Reichl18-Dec-02 22:39

Dominik Reichl

18-Dec-02 22:39

First you have to load the bitmap using the LoadBitmap function. This function needs the instance of the app and an LPCTSTR string identifing the resource.

HBITMAP hbm;

hbm = LoadBitmap(hInstance, MAKEINTRESOURCE(IDB_REDCHICKEN));

...

DeleteObject(hbm);

Don't forget to release the bitmap handle using DeleteObject.

Big Grin | :-D

-Dominik

Re: Problem with CFileDialog

PDStone18-Dec-02 22:24

PDStone

18-Dec-02 22:24

Try this, I haven't checked it but somthing along these lines should do it

char szFilePath[_MAX_PATH + 1];
char szDir[_MAX_DIR + 1];
char szDrive[_MAX_DRIVE + 1];
CString szFile;

::GetModuleFileName(NULL, szFilePath, MAX_PATH);
::_splitpath(szFilePath, szDrive, szDir, NULL, NULL);

szFile = szDrive + szDir + ""MyFile.txt"

Message transfer between two classes?

chen18-Dec-02 21:32

chen

18-Dec-02 21:32

Hi,

In a dialog based application, I have two classes such as

class A
{
do some calculation with a thread;
}

class B : public CDialog
{
here a have a static control, to show some text or numberical
information with the varible CSting m_show;
}

My problem is how to show the text info (class A) in the main dialog (class B) when the thread is started?

Thanks in advance!

chen

Re: Message transfer between two classes?

Rage18-Dec-02 21:42

Rage

18-Dec-02 21:42

I did something like this a few months ago. B was my main Dialog, so I just used AfxGetMainWnd in A to retrieve a Cwnd* which I casted on the B class, just as you do with the thread parameter. The result of the operation was that I had a pointer on the B class inside A, and I synchronized the whole with Critical_section, in order not to show in B data being changed simultaneously in A. Sleepy | :zzz:

A naive question : is it not possible to put your A data in a struct, and post it through a user message to B (I have really no idea if this is possible or not Unsure | :~

)?

~RaGE();

Re: Message transfer between two classes?

chen18-Dec-02 21:53

chen

18-Dec-02 21:53

Hi RaGE,

Thank you very much for your reply!

I want to try the first method, but would you please say that in more detail or give me an simple example project?

Best Regards,

chen

Re: Message transfer between two classes?

Rage18-Dec-02 23:35

Rage

18-Dec-02 23:35

Declare

CRITICAL_SECTION m_cs;
int *m_myData;   //or whatever it is

as member variables in B.
In OnInitDialog of B :

InitializeCriticalSection(&m_cs);

So, in the thread A :

CWnd* pWnd=AfxGetMainWnd();
CMainDlg *pMainDlg=(CMainDlg*)pWnd;   //where CMainDlg is your B class

... do some stuff ...

EnterCriticalSection(&pMainDlg->m_cs);
pMainDlg->m_myData[8]=22;  //or whatever
LeaveCriticalSection(&pMainDlg->m_cs);

And in the "show" section of B:

EnterCriticalSection(m_cs);
//Here update Data display
LeaveCriticalSection(m_cs);

So that's the start. You may have member variables in B which simply copies member variables of A just for display purposes. Of course, this is not a _good_ way to do multithreading, but i think that it is simple enough, and it works if the updating of data in the thread is not too time-critical.

If this doesn't work, you're going to use CEvent's ...

~RaGE();

Re: Message transfer between two classes?

Joe Woodbury19-Dec-02 5:33

Joe Woodbury

19-Dec-02 5:33

If all you need to do is transfer a numeric value, use InterlockedExchange() which allows you to set a LONG as an atomic operation. (See help for explanation of Interlocked calls--if you do multithreading you should understand these.)

Re: Set current date and time from the computer.Pls Help..Thanks

Christian Graus18-Dec-02 20:42

Christian Graus

18-Dec-02 20:42

dianazheng wrote:
// Get the current time
CTime curTime = CTime::GetCurrentTime();

//Get the current date
CTime curDate = CTime::GetCurrentTime();

What is the point of this ? Both these objects are the same.

dianazheng wrote:
//Display the current date
m_sDate = curDate.Format("%b / %d / %y");

// Display the current time
m_sTime = curDate.Format("%H:%M:%S");

MSDN does not document these methods, have you tried using GetMonth/GetYear/GetDay instead ?

Christian

No offense, but I don't really want to encourage the creation of another VB developer.
- Larry Antram 22 Oct 2002

C# will attract all comers, where VB is for IT Journalists and managers - Michael
P Butler 05-12-2002

Again, you can screw up a C/C++ program just as easily as a VB program. OK, maybe not
as easily, but it's certainly doable. - Jamie Nordmeyer - 15-Nov-2002

Re: Set current date and time from the computer.Pls Help..Thanks

Rage18-Dec-02 21:33

Rage

18-Dec-02 21:33

Christian Graus wrote:
// Display the current time
m_sTime = curDate.Format("%H:%M:%S");

MSDN does not document these methods, have you tried using GetMonth/GetYear/GetDay instead ?

Actually, I have this one in my MSDN, so I guess that's why dianzheng wrote that "it works for time". Anyway, Chris is right, GetMonth/Year/Day is the best way to do it.

~RaGE();

Re: Set current date and time from the computer.Pls Help..Thanks

dianazheng18-Dec-02 21:57

dianazheng

18-Dec-02 21:57

i have try the get month get day and get year but it still can't work that why i change it to tis way. Using this way i can get the time but i coulsn't get the date..
pls help....thanks

Re: Set current date and time from the computer.Pls Help..Thanks

Rage18-Dec-02 23:18

Rage

18-Dec-02 23:18

dianazheng wrote:
i have try the get month get day and get year

... Confused | :confused:

... What's wrong ? Could you post your code again ? I'll give it a try inbetween.

~RaGE();

Re: Set current date and time from the computer.Pls Help..Thanks

Rage19-Dec-02 0:06

Rage

19-Dec-02 0:06

Ok, this runs perfectly :

COleDateTime dTime;
dTime = COleDateTime::GetCurrentTime();
int d=dTime.GetDay();
int m=dTime.GetMonth();
int y=dTime.GetYear();
m_sDate.Format("%i / %i / %i",d,m,y);

~RaGE();

Re: Set current date and time from the computer.Pls Help..Thanks

dianazheng19-Dec-02 15:22

dianazheng

19-Dec-02 15:22

Really thanks for your help,i can display the date and time directly from the computer but now i have face with another problem hope you can help me also...Thanks

I have this two error

C:\Program Files\Microsoft Visual Studio\VC98\MFC\SRC\DLGDATA.CPP(170) : error C2065: '_countof' : undeclared identifier

C:\Program Files\Microsoft Visual Studio\VC98\MFC\SRC\DLGDATA.CPP(181) : error C2065: 'AfxSetWindowText' : undeclared identifier

which i really don't know what are they but they come from the function below...Hope you can help...

AFX_STATIC void AFX_CDECL _Afx_DDX_TextWithFormat(CDataExchange* pDX, int nIDC,
LPCTSTR lpszFormat, UINT nIDPrompt, ...)
// only supports windows output formats - no floating point
{
va_list pData;
va_start(pData, nIDPrompt);

HWND hWndCtrl = pDX->PrepareEditCtrl(nIDC);
TCHAR szT[32];
if (pDX->m_bSaveAndValidate)
{
// the following works for %d, %u, %ld, %lu
::GetWindowText(hWndCtrl, szT, _countof(szT));
if (!_AfxSimpleScanf(szT, lpszFormat, pData))
{
AfxMessageBox(nIDPrompt);
pDX->Fail(); // throws exception
}
}
else
{
wvsprintf(szT, lpszFormat, pData);
// does not support floating point numbers - see dlgfloat.cpp
AfxSetWindowText(hWndCtrl, szT);
}

va_end(pData);
}

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