Re: sql query - C / C++ / MFC Discussion Boards

Re: Parsing Dataset.GetXml() with xsl into html...

reet12319-Oct-06 20:13

reet123

19-Oct-06 20:13

Thank you, I solved my problem alredy with System.Xml.XmlNamespaceManager.

sql query

zizzzz8-Oct-06 22:53

zizzzz

8-Oct-06 22:53

hi,
my query is like this
if(!recset1.Open( CRecordset::forwardOnly,
_T( "SELECT Controller_Name FROM T_controller WHERE Port_ID='0'") ,CRecordset::readOnly))

I want that my condition WHERE become a parameter WHERE Port_ID=str
how can i do this
thanks

Re: sql query

zizzzz8-Oct-06 23:07

zizzzz

8-Oct-06 23:07

so I tried this
wsprintf(szBuffer,"SELECT Controller_Name FROM T_controller WHERE Port_ID='0'");

if(!recset1.Open( CRecordset::forwardOnly,
szBuffer ,CRecordset::readOnly))

but when i change Port_ID='0' with Port_ID=str I have a problem when running the programm

I declare CString str="0"

Re: sql query

toxcct8-Oct-06 23:14

toxcct

8-Oct-06 23:14

use CString::Format().
you first format the string (sql query) with the parameters it has to receive, and then forward it...

TOXCCT >>> GEII power

[VisualCalc 3.0 updated ][Flags Beginner's Guide new! ]

Re: sql query

zizzzz8-Oct-06 23:24

zizzzz

8-Oct-06 23:24

sorry but I don't understand

Re: sql query

toxcct8-Oct-06 23:28

toxcct

8-Oct-06 23:28

wsprintf(szBuffer, _T("SELECT Controller_Name FROM T_controller WHERE Port_ID='%s'"), str);

TOXCCT >>> GEII power

[VisualCalc 3.0 updated ][Flags Beginner's Guide new! ]

Re: sql query

Hamid_RT9-Oct-06 1:25

Hamid_RT

9-Oct-06 1:25

I agree with tocct why you dont use of CString::Format

WhiteSky

Re: sql query

David Crow9-Oct-06 4:19

David Crow

9-Oct-06 4:19

Regardless of whether CString::Format() or sprintf() is used, it has to be used correctly. Simply shoving MFC at the problem is not an automatic fix.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

Re: sql query

Hamid_RT9-Oct-06 7:26

Hamid_RT

9-Oct-06 7:26

Hi DavidCrow,
how are you
Generaly I dont use from wsprintf because:
From the MSDN
"Security Alert Using this function incorrectly can compromise the security of your application"

WhiteSky

"COleDateTime::GetCurrentTime()" Crashes??

VCSharp0078-Oct-06 22:30

VCSharp007

8-Oct-06 22:30

Hi,
call to "COleDateTime::GetCurrentTime()" get crashed in my MFC aplication.
I am using Windows XP, SP2.
Development environment is Visual Studio 6 with Platform SDK for XP SP2.

Thanx in advance.

Re: "COleDateTime::GetCurrentTime()" Crashes??

Stephen Hewitt8-Oct-06 22:42

Stephen Hewitt

8-Oct-06 22:42

The following information is always helpful when diagnosing a crash:
- The type of exception generated.
- The machine code around the faulting instruction.
- The call stack to the faulting instruction.
- The source code around the faulting instruction.

Steve

Re: "COleDateTime::GetCurrentTime()" Crashes??

prasad_som8-Oct-06 22:52

prasad_som

8-Oct-06 22:52

I second stephen on this.
Give some code.

Prasad
Notifier using ATL | Operator new[],delete[][^]

Re: "COleDateTime::GetCurrentTime()" Crashes??

Nibu babu thomas9-Oct-06 1:33

Nibu babu thomas

9-Oct-06 1:33

VCSharp007 wrote:
"COleDateTime::GetCurrentTime()" get crashed in my MFC aplication

COleDateTime::GetCurrentTime() has an issue since it uses the underlying time_t type for returning time. Now when year 2038 janhappens time_t reaches it's limit hence wraps around.

Instead of COleDateTime::GetCurrentTime() try using GetLocalTime. GetLocalTime returns local system time based on your timezone.

This is could be the problem. Unsure | :~

More info[^]

Nibu thomas
A Developer

Programming tips[^] My site[^]

Re: "COleDateTime::GetCurrentTime()" Crashes??

David Crow9-Oct-06 4:21

David Crow

9-Oct-06 4:21

Nibu babu thomas wrote:
This is could be the problem.

How, since we are roughly 32 years away?

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

Re: "COleDateTime::GetCurrentTime()" Crashes??

Nibu babu thomas9-Oct-06 17:22

Nibu babu thomas

9-Oct-06 17:22

DavidCrow wrote:
How, since we are roughly 32 years away?

Yeah true. But our client tested our product with year greater than 2038 to see if such issues are handled properly. Hence I thought this could be the problem, since our application crashed when it was tested like this.

Nibu thomas
A Developer

Programming tips[^] My site[^]

Re: "COleDateTime::GetCurrentTime()" Crashes??

David Crow10-Oct-06 2:49

David Crow

10-Oct-06 2:49

Nibu babu thomas wrote:
COleDateTime::GetCurrentTime() has an issue since it uses the underlying time_t...

Actually it uses a DATE, which is a double. CTime has the year 2038 problem.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

Re: "COleDateTime::GetCurrentTime()" Crashes??

Hamid_RT9-Oct-06 1:37

Hamid_RT

9-Oct-06 1:37

Can you be more specific

WhiteSky

Re: "COleDateTime::GetCurrentTime()" Crashes??

Galatei9-Oct-06 1:52

Galatei

9-Oct-06 1:52

Hi,

Ensure that COleDateTime::GetCurrentTime() is not assigned directly to other variable than COleDateTime class type.

Try if this will throw an exception:

COleDateTime dateTime = COleDateTime::GetCurrentTime();

Best regards

VC++ Substitute for SetIcon??

Programm3r8-Oct-06 21:54

Programm3r

8-Oct-06 21:54

Hi,

What is the VC++ Substitute for the MFC <code>SetIcon</code> function??

Thanx in Advance

The only programmers that are better than C programmers are those who code in 1's and 0's..... Smile | :)

Programm3r

Re: VC++ Substitute for SetIcon??

_AnsHUMAN_ 8-Oct-06 22:11

_AnsHUMAN_

8-Oct-06 22:11

I think you should look at DrawIcon() /LoadIcon()
SetClassLong(): Your application can replace a class icon by using the SetClassLong function.

Somethings seem HARD to do, until we know how to do them.
Wink | ;-)

_AnShUmAn_

Re: VC++ Substitute for SetIcon??

PJ Arends8-Oct-06 22:14

PJ Arends

8-Oct-06 22:14

Use the WM_SETICON message.

You may be right
I may be crazy
-- Billy Joel --

Within you lies the power for good, use it!!!

Re: VC++ Substitute for SetIcon??

David Crow9-Oct-06 4:28

David Crow

9-Oct-06 4:28

For a static control, send it a STM_SETICON message. For a button, send it a BM_SETIMAGE message. For all others, send them a WM_SETICON message.

"Approved Workmen Are Not Ashamed" - 2 Timothy 2:15

"Judge not by the eye but by the heart." - Native American Proverb

:-: HInstance Question :-:

Programm3r8-Oct-06 21:13

Programm3r

8-Oct-06 21:13

Hi all,

How would I go about getting hold of the handle to the instance of the application.

<code>
HINSTANCE hInst
</code>
I know in MFC one would use <code>AfxGetInstanceHandle()</code> ,so what can I use in good old VC++?

Thanx in advance

The only programmers that are better than C programmers are those who code in 1's and 0's..... Smile | :)

Programm3r

Re: :-: HInstance Question :-:

prasad_som8-Oct-06 21:20

prasad_som

8-Oct-06 21:20

what about first parameter of Winmain ? Smile | :)

.
From MSDN;

int WINAPI WinMain(
  HINSTANCE hInstance,      // handle to current instance <---   
  HINSTANCE hPrevInstance,  // handle to previous instance
  LPSTR lpCmdLine,          // command line
  int nCmdShow              // show state
);

Prasad
Notifier using ATL | Operator new[],delete[][^]

Re: :-: HInstance Question :-:

Programm3r8-Oct-06 21:28

Programm3r

8-Oct-06 21:28

Thanx for the response. The other question I have is:

<pre?
in mfc="" one="" would="" use="" <code="">SetIcon</code> to set the Icon, what can I use for VC++, <code>LoadIcon</code> ???

Thanx Again

The only programmers that are better than C programmers are those who code in 1's and 0's..... Smile | :)

Programm3r

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