C / C++ / MFC

Jimmy Ehrnström8-Nov-01 2:52

Jimmy Ehrnström

8-Nov-01 2:52

When using SetParamNULL I get the same result, ie. a new record is created when one should just be updated.

I also get the wrong id back when doing a requery to find the id of the added/updated entry.

If I remove the parameter from my recordset, or give it a value, everything works just fine.

Tomasz Sowinski8-Nov-01 3:03

8-Nov-01 3:03

The problem may be related to the fact that you're trying to compare a column in DB to NULL. While some databases permit that, others do not - generally, you should use IS NULL instead.

Tomasz Sowinski -- http://www.shooltz.com

Jimmy Ehrnström8-Nov-01 3:09

Jimmy Ehrnström

8-Nov-01 3:09

Yes, it might be. But with my current design, building on CRecordsets and filters with parameters, it's difficult to manually compare the field with IS NULL.

I'm using MS SQL server so I really don't think this should be the problem. But as it looks right now I'm probably wrong. Frown | :(

Thanks for your help though!

Tomasz Sowinski8-Nov-01 3:44

8-Nov-01 3:44

SET ANSI_NULLS controls how SQLServer compares against NULL.

Tomasz Sowinski -- http://www.shooltz.com

Carlos Antollini8-Nov-01 3:34

Carlos Antollini

8-Nov-01 3:34

Jimmy:
The Filter is the where of a SQL Sentence.
When you make a select you need to make this

Select * from Table where Field1 = anyvalue and Field2 Is Null

Is for this that you need to use

prsFoo->m_strFilter = "ColumnA=anyvalue AND ColumnB=anyvalue AND ColumnC Is Null";

Best Regards....

Green Alien | [Alien]

Tomorrow is Friday!!! Party and Beer | [beer]

Carlos Antollini.

SetFocus hassles

Christian Graus8-Nov-01 0:12

8-Nov-01 0:12

I have now got SetFocus calling when my mouse leaves my window, and TrackMouseEvent when I am in it. The trouble is that in MouseMove I check to see if I am in the rect, and if so, check if TrackMouseEvent is set, and set it if I need to. Otherwise I call SetCapture. Unless I comment out the call to _TrackMouseEvent that sets it in MouseMove, I cannot click on any of the buttons in my PropertySheet, nor can I drag the title bar or press the close button. I tried sending the message via the property sheet, but it didn't make any difference.

Can anyone tell me how all this junk is supposed to work ? I can't find an implimentation that allows me to capture the mouse outside my dialog, act normally within it, AND drag the dialog if I want to.

Christian

After all, there's nothing wrong with an elite as long as I'm allowed to be part of it!! - Mike Burston Oct 23, 2001

Tomasz Sowinski8-Nov-01 0:43

8-Nov-01 0:43

Can anyone tell me how all this junk is supposed to work ?

I can't. But I can smell the global hook around Smile | :)

Tomasz Sowinski -- http://www.shooltz.com

Christian Graus8-Nov-01 0:52

8-Nov-01 0:52

I need to hook the mouse move so I can set/release the capture there ? That sounds like a fine idea. Actually I've always wanted to learn about hooks, but never had an excuse to.

Christian

After all, there's nothing wrong with an elite as long as I'm allowed to be part of it!! - Mike Burston Oct 23, 2001

Tomasz Sowinski8-Nov-01 0:58

8-Nov-01 0:58

I need to hook the mouse move so I can set/release the capture there ?

No - with a global mouse hook your procedure will receive all mouse messages. The need for SetCapture disappears, everyone is happy. The only drawback is that global hook must live in a DLL.

Tomasz Sowinski -- http://www.shooltz.com

Christian Graus8-Nov-01 1:01

8-Nov-01 1:01

OK, will I be able to turn it off and on ? I only need all messages in one specific dialog.

Christian

After all, there's nothing wrong with an elite as long as I'm allowed to be part of it!! - Mike Burston Oct 23, 2001

Tomasz Sowinski8-Nov-01 1:03

8-Nov-01 1:03

OK, will I be able to turn it off and on ?

Yes, UnhookWindowsHookEx has a nice name and does the magic Big Grin | :-D

Tomasz Sowinski -- http://www.shooltz.com

Christian Graus8-Nov-01 1:13

Faking mouse movement and clicks

8-Nov-01 1:13

Thanks for the info. This will save my bacon nicely, as well as giving me a good excuse to finally learn how to put together a dll, and a Windows hook.

Christian

After all, there's nothing wrong with an elite as long as I'm allowed to be part of it!! - Mike Burston Oct 23, 2001

Combo box nightmare

-Dy7-Nov-01 23:38

-Dy

7-Nov-01 23:38

Arrggghhh....

On one of my dialogs, I've got a combo box with its type set to Drop List, and Owner Draw set to No. There's nothing unusual about the combo box, it contains four items (for now), but, for some reason, when you make the combo box drop, you can only see one item in the list. There are the usual scroll bars on the right, and all the items are there, but what I'm really after is having the box display all four items without the scroll bars (when dropped). I've tried disabling Vertical scroll, enabling Disable no scroll, and just about everything I can think off, but none of them give the desired effect.

Any ideas folks? Its such a basic thing and really doing my head in!

Re: Combo box nightmare

7-Nov-01 23:45

when you are in your dialog resource window (the window where you were when you first put the combobox on the dialog) click on the arrow of the combobox as if you were going to drop it down and the bottom 'handle' should turn from white to blue. Take that and drag it down and the 'mask' around the combobox should have a bunch of empty space under the box. The empty space is how far down your combobox will drop down during runtime.

Hope this helps.

-Zack

Re: Combo box nightmare

-Dy8-Nov-01 0:20

-Dy

8-Nov-01 0:20

Zack. You should be paid more! Thanks very much.

7-Nov-01 22:50

Is there a good method for faking mouse movements and clicks? I want to be able to move the mouse to a specific coordinate and make it 'click' that point (not inside of my application).

Re: Faking mouse movement and clicks

Tomasz Sowinski8-Nov-01 0:05

Re: Faking mouse movement and clicks

8-Nov-01 0:05

Use mouse_event or SendInput.

Tomasz Sowinski -- http://www.shooltz.com

8-Nov-01 0:11

Thanks a ton!

create software (registry) array

7-Nov-01 22:40

In your configuration screen by add/remove programs you can see a list of all installed software. Now I want to make an array that does the same, show me all the installed software by name. Then together with your computer name send that information to a text file. Later on the system administrator can check the text file and send it to a database.
Can someone help me with this problem.
Thanks
Hessel

Re: create software (registry) array

Nish Nishant7-Nov-01 22:45

Nish Nishant

7-Nov-01 22:45

this is the registry key

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall

enumerate its sub-keys

Nish

Sonork ID 100.9786 voidmain

VC++ and SQL insert

Tryhard7-Nov-01 19:42

Tryhard

7-Nov-01 19:42

Hi Y'all

I am trying to insert a CString into a database table.

this is what I have but it literally puts the %s into the table remove the ' and I get an error.

CString CSWholesentence = "This is the whole sentence";

SqlString = "INSERT INTO Sentences (SENTENCE) "
"VALUES ('%s')", CSWholesentence;

database.ExecuteSQL(SqlString);

Any help greatly appreciated.
Cheers
Confused | :confused:

Tryhard

Nish Nishant7-Nov-01 20:11

Nish Nishant

7-Nov-01 20:11

use this instead

SqlString = "INSERT INTO Sentences (SENTENCE) VALUES('";
Sqlstring += CSWholeSentence;
SqlString += "')";

Nish

Sonork ID 100.9786 voidmain

Tryhard7-Nov-01 20:48

Tryhard

7-Nov-01 20:48

Thanks Guys.

Sorted.

Tryhard Smile | :)

Michael Dunn7-Nov-01 20:26

Michael Dunn

7-Nov-01 20:26

The % replacement only works in sprintf(), CString::Format(), and their variations. It is not a feature of C++.

CString sql;
 
  sql.Format ( _T("INSERT INTO Sentences (SENTENCE) VALUES ('%s')"), (LPCTSTR) CSWholesentence );

Note that you need to cast a CString to LPCTSTR (as I did above) when it's being used as the string for a %s substitution.

--Mike--
http://home.inreach.com/mdunn/
#include "witty_sig.h"
Heart | [heart]

your

with

and