Re: ODBC with VC++ - C / C++ / MFC Discussion Boards

Re: Key Entry

Mike Winter7-Oct-05 0:44

Mike Winter

7-Oct-05 0:44

Hi Khan++

Thanks for your help - yep thats got it now!

Thanks again

Mike

OPC

Marc Soleda6-Oct-05 22:32

Marc Soleda

6-Oct-05 22:32

Is anybody developing apps/components that are OPC compliance. I just wanted to know if OPC is still alive and it's used as standard for industrial client / server applications.

Marc Soleda.

... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.

Re: OPC

Blake V. Miller8-Oct-05 15:12

Blake V. Miller

8-Oct-05 15:12

OPC clients are developed all the time at Wonderware - www.wonderware.com
Many third parties write OPC clients as well and OPC servers for the PLC devices.

Re: OPC

Marc Soleda9-Oct-05 20:27

Marc Soleda

9-Oct-05 20:27

I just wondered if OPC is the main protocol/standard that is used for inustrial communications. Thanks for ithe info.

What are trends in this item, I mean, are there any other teck or standard that some companies are investing ?

Marc Soleda.

... she said you are the perfect stranger she said baby let's keep it like this... Tunnel of Love, Dire Straits.

ODBC with VC++

sirtimid6-Oct-05 22:10

sirtimid

6-Oct-05 22:10

I try to open a table "Customer" and select a specific record of it with the Open property as follows:
m_pSet->Open(CCustomer::dynaset,"SELECT NAME FROM CUSTOMER WHERE ID = 5"
This command throws the following exception error:
"Invalid character value for cast specification"

Does anyone know what have I done wrong and how to make it work properly?

Thanks in advance

Re: ODBC with VC++

KaЯl7-Oct-05 2:08

KaЯl

7-Oct-05 2:08

Did you try m_pSet->Open(CRecordSet::dynaset,_T("SELECT NAME FROM CUSTOMER WHERE ID = 5")) ?

The great error of nearly all studies of war has been to consider war as an episode in foreign policies, when it is an act of interior politics - Simone Weil
Fold with us! ¤ flickr

Re: ODBC with VC++

sirtimid7-Oct-05 2:59

sirtimid

7-Oct-05 2:59

Yes I already tried it.
I saw that this was because in the DoFiledExchange() the first field must be of the same type with the requested one in the Select clause.

Thanks very much for your time!
Any idea?

Re: ODBC with VC++

KaЯl7-Oct-05 4:07

KaЯl

7-Oct-05 4:07

sirtimid wrote:
this was because in the DoFiledExchange() the first field must be of the same type with the requested one in the Select claus
I watched the source code of the CRecordSet class, the enum being public, I suppose your class can inherit it so your syntax is also correct (even if misleading, but it is just my opinion)

I'm not an expert in database access, but I'm not sure the problem comes from this part of code. After some googling[^], I found this:

"Typically, this error means the import process is trying to convert (cast) a value in the text file from a character data type to another data type such as numeric or datetime and the value in the text file is not valid for the new data type. "[^]

HTH,

K.

The great error of nearly all studies of war has been to consider war as an episode in foreign policies, when it is an act of interior politics - Simone Weil
Fold with us! ¤ flickr

Re: ODBC with VC++

sirtimid7-Oct-05 4:22

sirtimid

7-Oct-05 4:22

OK I found why this error occured.
This was because in the DoFieldExchanged() I have all the fields of the table, so the Open() should be with NULL value at the second argument (LPCTSTR lpszSQL=NULL).
So, I tried the following:

m_pSet = new CDatabaseSet;
m_pSet->m_strFilter = "ID = 48";
m_pSet->Open(CDatabaseSet::dynaset);

Now the problem is that it works properly when the filter has a field of numeric type.
When it is of character type it doesn't work properly.
It returns the last record even if it shouldn't return anything.
Any idea on why this happens???

Thanks again for your help!!!

Help needed - to retrieve the security permissions over a Folder/file

6-Oct-05 22:03

I need to check the security permissions over a folder(which means i need to iterate over the ACE's from the DACL)and check whether the logged in user has some permissions over them.

Heres how i approached this problem -

1)I am using GetFileSecurity() function to get the Security descriptor for
this folder.
2)Next i check whether this descriptor is valid using IsValidSecurityDescriptor().It returns TRUE.

3)Next, i am using the function GetSecurityDescriptorDacl() to get the DACL.
4)The second parameter to this function is an out parameter (a pointer to a bool)which is set to TRUE if DACL is present.

IT is here that in this out parameter i am getting a FALSE value.
What does this imply(coz right clikin the folder to retrieve the security permissions i can get a DACL)

please help

Anmol

-- modified at 7:44 Friday 7th October, 2005

mfc edit box

swaapu6-Oct-05 21:58

swaapu

6-Oct-05 21:58

hi!
i am working on an MFC SDI Application. I have an EditBox on a dialog for dispalying path of files. I hav also used a Button for browsing files.
My Browse button is working , but, i also want that "the path of the file can be entered directly into the edit box." How to do it?
But, I had not used EditBox earlier as i am new to mfc programming. can anybody help me at this issue.
Thanx for providing me help

Re: mfc edit box

P-Rex6-Oct-05 22:43

P-Rex

6-Oct-05 22:43

CString strPath<br />
GetDlgItemText(IDC_EDIT_PATH, strPath);<br />

Re: mfc edit box

toxcct6-Oct-05 22:42

toxcct

6-Oct-05 22:42

use CWnd::SetWindowText(CString) for this:

((CEdit*)GetDlgItem(IDC_MY_EDIT))->SetWindowText(strFileName);
((CEdit*)GetDlgItem(IDC_MY_EDIT))->GetWindowText(strFileName); 
or
 
m_MyEdit.SetWindowText(strFileName);
m_MyEdit.GetWindowText(strFileName);

TOXCCT >>> GEII power
[toxcct][VisualCalc]

Re: mfc edit box

ThatsAlok7-Oct-05 0:32

ThatsAlok

7-Oct-05 0:32

swaapu wrote:
But, I had not used EditBox earlier as i am new to mfc programming. can anybody help me at this issue.
Thanx for providing me help

Using ClassWizard(Ctrl + W ) associate a CString Variable with the Edit Box.. When ever you need the value from the Edit Box

From Edit Box
 UpdateData(<code>TRUE</code>);
MessageBox( m_strEditBox,"Data in Edit Box");

TO Edit Box
 m_strEditBox="codeproject";
 UpdateData(<code>FALSE</code>);

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

cheers,
Alok Gupta
VC Forum Q&A :- I/ IV

SWF in VC++

Nishad S6-Oct-05 21:44

Nishad S

6-Oct-05 21:44

How can I play swf (flash) file in VC/MFC without the help of standard flash player?
Is there any library available?

- NS -

Re: SWF in VC++

Axonn Echysttas6-Oct-05 22:38

Axonn Echysttas

6-Oct-05 22:38

It is possible if you wish to use the ActiveX that Macromedia provides you with ::- ). I did this plenty of times with success in Visual Basic and C#. I will write an article about this perhaps if I'll have time, unfortunately, my time is quite scarce.

You can find the ActiveX on your computer in WINDIR\System32\Macromed\Flash\Flash.ocx. I don't know how to include ActiveXes in Visual C++ but I'm sure that the gurus around here can tell you about that. After you include the ActiveX, you can use its properties and methods to play any kind of Flash in your application. The nice part is that you can even communicate with Flash!! You can send data to Flash or receive from Flash. Just inspect the ActiveX's methods and the documentation by Macromedia.

-= E C H Y S T T A S =-
The Greater Mind Balance

Serial Communication in MFC

vikas amin6-Oct-05 21:30

vikas amin

6-Oct-05 21:30

Can anyone tell me the best way
to use the serialport in MFC
application.
If anyone has used and tested any
class then it will me more helpfull

Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com

Re: Serial Communication in MFC

Roger Stoltz6-Oct-05 21:42

Roger Stoltz

6-Oct-05 21:42

Have a look among the articles in the System section:
http://www.codeproject.com/system/#Hardware+programming[^]

--
Roger

Re: Serial Communication in MFC

vikas amin7-Oct-05 2:08

vikas amin

7-Oct-05 2:08

Thank you
hope my problem is solved Cool | :cool:

Vikas Amin
Embin Technology
Bombay
vikas.amin@embin.com

white remnant occur when scroll bar is click.

babyspidy6-Oct-05 21:20

babyspidy

6-Oct-05 21:20

Hello again guys.

As my project is almost finish, I have few bugs and some display problems.
As I created a SDI CHtmlView base class in MFC/VC++. When the application is launched, it works fine. When I select a new IE window or any other window application on top of my project's application and then click the scroll bar from my project's application, my project displayed white background from the remnant of the other window application. I don't know why this is happens. I don't know if it can be fix in program or Windows problem or what?. It only happens when clicking the scroll bar of my project's application that is behind of other window application. If I only click any part of my project's window, that behavior didn't occur. Confused | :confused:

Any idea why this behaviors happen? I tried googling this behavior but can't find any related topic with this.

With great power comes a great responsibility.

Re: white remnant occur when scroll bar is click.

KaЯl7-Oct-05 2:02

KaЯl

7-Oct-05 2:02

To be sure all the window is added to the clipping region, you could invalidate all the window (using CWnd::InvalidateRect(NULL)) when it gets the focus, or when the scrolling is activated.

The great error of nearly all studies of war has been to consider war as an episode in foreign policies, when it is an act of interior politics - Simone Weil
Fold with us! ¤ flickr

Re: white remnant occur when scroll bar is click.

babyspidy7-Oct-05 4:28

babyspidy

7-Oct-05 4:28

Thanks for your reply.
However, I'm just a newbie with MFC, may I ask how can I do that?
or where part in my code do I put that CWnd::InvalidateRect(NULL)?
Sorry for asking more.

Thanks a lot.

With great power comes a great responsibility.

Re: white remnant occur when scroll bar is click.

KaЯl7-Oct-05 4:44

KaЯl

7-Oct-05 4:44

You could do this by catching the messages WM_HSCROLL and WM_VSCROLL

<code>
void CMyView::OnHScroll(UINT nSBCode, UINT nPos, CScrollBar* pScrollBar) 
{
	InvalidateRect(NULL);
	<CBaseView>::OnHScroll(nSBCode, nPos, pScrollBar);	
}

void CMyView::OnVScroll(UINT nSBCode, UINT nPos, CScrollBar* pScrollBar) 
{
	InvalidateRect(NULL);
	<CBaseView>::OnVScroll(nSBCode, nPos, pScrollBar);	
}

Replace CBaseView by the name of the base class view you use (CHtlmView I presume)
This code will ensure all the window will be marked as to be redrawn.

Hope this work Smile | :)

The great error of nearly all studies of war has been to consider war as an episode in foreign policies, when it is an act of interior politics - Simone Weil
Fold with us! ¤ flickr

Re: white remnant occur when scroll bar is click.

babyspidy7-Oct-05 5:00

babyspidy

7-Oct-05 5:00

Thanks again.
I tried your code, but still there's a white remnant when I click the scroll bar. I just delete the '::' from OnVScroll and OnHScroll in order not to catch an error upon compiling. . Confused | :confused:

Ok, I get a handle for WM_HSCROLL and WM_VSCROLL in PreTranslateMessage(MSG* pMsg). I don't know what attributes will I put in OnVScroll(..) and OnHScroll(..).

With great power comes a great responsibility.

-- modified at 11:04 Friday 7th October, 2005

Re: white remnant occur when scroll bar is click.

babyspidy7-Oct-05 4:47

babyspidy

7-Oct-05 4:47

Ok, as you suggested using InvalidateRect(NULL) and as I read from microsoft's site, here's what I did on my project.

At my CMyProjectView.cpp, I made this.

void CMyProjectView.cpp::OnUpdate()
{
InvalidateRect(NULL);
return;
}

but nothing's happened when I run again my project. Confused | :confused:

With great power comes a great responsibility.

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