C / C++ / MFC Discussion Boards

mevatron117-Dec-08 11:16

17-Dec-08 11:16

Do you have an example of a stored procedure to do that for my simple tables? Will the imageBlob be a problem for the stored procedure?

-Will

Re: Using CRecordset with foreign keys

led mike18-Dec-08 6:53

led mike

18-Dec-08 6:53

mevatron1 wrote:
Do you have an example of a stored procedure to do that for my simple tables?

Will, I also saw your reply to David. While there might be an example identical to your scenario I am not aware of one. That said there is certainly much information about stored procedures. They can be product specific so make sure you use the documentation and tutorials for the database product you are working with. Also there is a Database forum here at code project.

I strongly urge you to take some time learning about database programming. Like most subjects in software development, there are choices that come with benefits and detractors and not knowing the details of the subject (database development ) can lead to undesirable results.

led mike

Re: Using CRecordset with foreign keys

mevatron118-Dec-08 7:17

mevatron1

18-Dec-08 7:17

Mike, Thank you very much for your advice. I will definitely continue to look into stored procedures to try to learn how to solve this problem.

-Will

Re: Using CRecordset with foreign keys

David Crow17-Dec-08 10:30

David Crow

17-Dec-08 10:30

What about wrapping the code in a transaction, like:

personTable.m_pDatabase->BeginTrans();
 
personTable.AddNew();
personTable.m_Name = "Joe";
personTable.Update();
 
personTable.Requery();
personTable.MoveLast();
 
personTable.m_pDatabase->CommitTrans();

I'm not sure if it's optimal, however.

"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

Re: Using CRecordset with foreign keys

mevatron117-Dec-08 11:16

mevatron1

17-Dec-08 11:16

I can certainly give this a try! Thanks for the reply!

-Will

Re: Using CRecordset with foreign keys

mevatron117-Dec-08 11:48

mevatron1

17-Dec-08 11:48

Sadly, this doesn't work.

I set a breakpoint on the personTable.Requery() line

personTable.m_pDatabase->BeginTrans();
 
personTable.AddNew();
personTable.m_Name = "Joe";
personTable.Update(); // <-- This inserts a new key == 1
 
personTable.Requery(); // <-- placed breakpoint here
personTable.MoveLast();
 
personTable.m_pDatabase->CommitTrans();

I then ran another instance of the program to let it run to completion first, so I ended up with the imageTable.PersonId == 2 for both rows in the imageTable. Thanks for your time!

-Will

About USB ports

ameyakoshti17-Dec-08 7:09

ameyakoshti

17-Dec-08 7:09

Few months back i had asked about how to disable USB ports thru vc++.
and i got replies saying disable it through registry.

one thing i forgot to ask.

if i disable the USB post through registry then will windows still recognise the USB ports??
and will it still send some power to it?
and is there any way to control the power to it?

basically m making a project on power management.
can someone help me out with it?

i need help on accessing BIOS from windows...

Re: About USB ports

Jonathan Davies17-Dec-08 7:33

Jonathan Davies

17-Dec-08 7:33

Hi,
Have a look at: http://msdn.microsoft.com/en-us/library/ms791235.aspx This is part of the setup api which I recently used to find the names of devices (such as usb ports). The documentation on this method mentions enabling/disabling. It seems cleaner to use these methods rather than access the registry directly. Have a look at http://www.codeproject.com/KB/wtl/DeviceInformation.aspx which is code I used to see the devices and might help. It does need WTL to compile though.

Re: About USB ports

ameyakoshti17-Dec-08 8:09

ameyakoshti

17-Dec-08 8:09

hey i jus saw the article

but this is want i dont like:
"DICS_DISABLE
Disables the device. If the device can be disabled but this function cannot disable the device dynamically, this function marks the device to be disabled the next time the machine reboots. "

i need to disable the USB port thru my prog and then enable it again without restarting the comp.

Re: About USB ports

Jonathan Davies18-Dec-08 2:07

Jonathan Davies

18-Dec-08 2:07

Hi,

I'd expect power saving to be apply to most devices, not just USB, so it's quite possible there is an API to do this. Just as the setup API I mentioned provided what I needed. In a quick search on MSDN I found http://msdn.microsoft.com/en-us/library/aa387973(VS.85).aspx. This starts off: "The CIM_PowerSupply class represents the capabilities and management of the power supply logical device.". I don't know if this applies to USB but this could be where you need to start researching.

Re: About USB ports

ameyakoshti18-Dec-08 3:20

ameyakoshti

18-Dec-08 3:20

hey thank you so much.
I'll search on that page for more info.Really thanks a lot for that link.Contains exactly what i need.

listview

trioum17-Dec-08 2:06

trioum

17-Dec-08 2:06

I want to show the icon with each record(row) in listview . I am using listview as recordview . how it is possible.

Trioum

Re: listview

VC++Maniac17-Dec-08 2:14

VC++Maniac

17-Dec-08 2:14

Create an imagelist (CImageList).
Add icons to the imagelist.
Attach it to the listctrl.
While inserting items pass the index of the icon in the imagelist to the insert function.

Re: listview

Jijo.Raj17-Dec-08 2:28

Jijo.Raj

17-Dec-08 2:28

Check out this tutorial[^]. It describes about everything about listctrl which includes how to add images in report view.

Regards,
Jijo.

_____________________________________________________

http://weseetips.com[^] Visual C++ tips and tricks. Updated daily.

inplace edit of doc title

VC++Maniac17-Dec-08 1:44

VC++Maniac

17-Dec-08 1:44

I need something similar to MSWord's "Type Your Title Here" or "[Type the document title]" thing in the view, so that the user can do in-place editing of the doc's title. How to start on this?

Please suggest.

Thanks
Ronnie.

Re: inplace edit of doc title

David Crow17-Dec-08 3:11

David Crow

17-Dec-08 3:11

Where is this at?

"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

Re: inplace edit of doc title

VC++Maniac17-Dec-08 19:59

VC++Maniac

17-Dec-08 19:59

This is still at start Smile | :)

I have this idea..
I will draw the text "Type Title Here" at the top of doc.
When user clicks on this text I will show a rectangle surrounding the text and a cursor at that position.
User types the title, I'll accept the input character by character and display it. As soon as the user clicks outside the rectangle I will hide the rectangle.

Should I go on with this? or
Have a better idea?

Please suggest.

Thanks
Ron

ShellExecute with new instance

K. Sushilkumar17-Dec-08 1:29

K. Sushilkumar

17-Dec-08 1:29

Hi All,

I am trying to open a web page using the following code.

ShellExecute(this->m_hWnd, _T("open"), _T("www.xyz.com"), NULL, NULL, SW_SHOWNORMAL);

It works well.
Consider,
Default browser is Mozilla Firefox.
An instance of the Mozilla Firefox is running with some tabs open in it.

The above code will open a new tab (www.xyz.com) in the existing instance.

Now what i want is to open my web page with new instance.

Thanks & Regards,
K. Sushilkumar.

Re: ShellExecute with new instance

L. Madhavan17-Dec-08 2:09

L. Madhavan

17-Dec-08 2:09

You will have to retrieve the path to the default browser and directly execute it, passing in the URL as a parameter.

ShellExecute(this->m_hWnd, _T("open"), pathToBrowser, _T("www.xyz.com"), NULL, SW_SHOWNORMAL);

Re: ShellExecute with new instance

Randor 17-Dec-08 2:12

Randor

17-Dec-08 2:12

Hi,

This ShellExecute documentation[^] states:

If the default Web browser currently runs, ShellExecute tells the instance that runs to go to your Uniform Resource Locator (URL). If it is not running, ShellExecute starts the application and then browses to your URL.

Looks like the default behavior. You may need to use CreateProcess[^] instead.

Best Wishes,
-David Delaune

Re: ShellExecute with new instance

Rahul Vaishnav17-Dec-08 2:17

Rahul Vaishnav

17-Dec-08 2:17

below code will open in new instance

ShellExecute(this->m_hWnd, _T("open"), _T("firefox.exe"), _T("www.google.com"), NULL, SW_SHOWNORMAL);

ShellExecute(this->m_hWnd, _T("open"), _T("iexplore.exe"), _T("www.google.com"), NULL, SW_SHOWNORMAL);

Re: ShellExecute with new instance

Stuart Dootson17-Dec-08 2:19

Stuart Dootson

17-Dec-08 2:19

K. Sushilkumar wrote:
The above code will open a new tab (www.xyz.com) in the existing instance

K. Sushilkumar wrote:
Now what i want is to open my web page with new instance.

Firefox decides (depending on the options you select in Firefox) where a URL should be opened. Your program has no way of altering that.

How to load bitmap to a button

Pryabu17-Dec-08 1:01

Pryabu

17-Dec-08 1:01

I have created a push button in a Toolbar. I want to add image to this button.How can i do this.

Re: How to load bitmap to a button

Hamid_RT17-Dec-08 1:11

Hamid_RT

17-Dec-08 1:11

Did you see CToolBar::LoadBitmap?

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

Re: How to load bitmap to a button

Pryabu17-Dec-08 1:15

Pryabu

17-Dec-08 1:15

I want to add for a particular button

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