C / C++ / MFC Discussion Boards

How I can access an external MS Access database (.mdb)

ATC13-Jun-03 16:48

13-Jun-03 16:48

Hi,

Let say I have a VC++ application and try to retrieve a data from an external "c:\file.mdb":

- Its Password is: PASSWORD
- It has two tables: Table1, Table2
- In Table1: it has two column titles: ID, Data

After I use:

<br />
CDaoDatabase	*pdb;<br />
<br />
pdb = new CDaoDatabase;	 <br />
pdb->Open ("c:\file.mdb", FALSE, FALSE, ";PWD = PASSWORD");<br />

How can I retrieve in Table1 the Data at a specific row by knowing the its ID, by the way let assume all fields are Text

Anyone can help me?

Many thanks

Re: How I can access an external MS Access database (.mdb)

John M. Drescher13-Jun-03 17:35

John M. Drescher

13-Jun-03 17:35

You are asking if you can open the file using C (not the database driver / server) or whatever language and search for the ID?

John

Re: How I can access an external MS Access database (.mdb)

ATC14-Jun-03 4:35

ATC

14-Jun-03 4:35

Hi,

I am using Visual C++ 6.0 project and through it I am trying to open a MicroSoft Access database file.mdb of an existed database from someone esle ... but I do know its environment (I do not have its class in my project)

*) Please verify my original request, it has more detail

Thanks

Hiding Mainframe without flicker

pranavamhari13-Jun-03 15:47

pranavamhari

13-Jun-03 15:47

Hi all,
please see the code below:

//add single doc template
..........

//process command line
CNewCommandLineInfo cmdInfo;
ParseCommandLine(cmdInfo);

if(!cmdInfo.m_bHasTasks)
{

m_pMainWnd->ShowWindow(SW_SHOWNORMAL);
m_pMainWnd->UpdateWindow();
}
else
{
m_pMainWnd->ShowWindow(SW_HIDE);
DoCommandLine(cmdInfo);
return FALSE;
}

Here, when i call showindow(SW_HIDE), the window first appears and then disappears. How can i prevent this flicker ? I must create the window BTW.

regards
hari

Hari Krishnan

How to get a sub-member's pointer

FlyingDancer13-Jun-03 15:43

FlyingDancer

13-Jun-03 15:43

For example,
Class CA{
...
int m_member;
...
}
Class CB{
instance=new CA;

}

Now I want to get CA.m_member's pointer in Class CB, how should I do?

Re: How to get a sub-member's pointer

John M. Drescher13-Jun-03 15:55

John M. Drescher

13-Jun-03 15:55

int* p = &(instance.m_member);

John

Re: How to get a sub-member's pointer

FlyingDancer13-Jun-03 16:02

FlyingDancer

13-Jun-03 16:02

It is wrong.
Don't add "&()";
Only add (*int) in advance.
that is:
(int *)CA.member

Re: How to get a sub-member's pointer

Tim Smith13-Jun-03 16:21

Tim Smith

13-Jun-03 16:21

That is a cast operator, not the address of operator.

&CA.member is correct.

Tim Smith

I'm going to patent thought. I have yet to see any prior art.

Re: How to get a sub-member's pointer

Ryan Binns14-Jun-03 4:50

Ryan Binns

14-Jun-03 4:50

Tim Smith wrote:
I'm going to patent thought. I have yet to see any prior art.

How true in this case Frown | :(

Ryan

Being little and getting pushed around by big guys all my life I guess I compensate by pushing electrons and holes around. What a bully I am, but I do enjoy making subatomic particles hop at my bidding - Roger Wright (2^nd April 2003, The Lounge)

Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late - John Nichol "Point Of Impact"

Re: How to get a sub-member's pointer

Michael Dunn13-Jun-03 16:33

Michael Dunn

13-Jun-03 16:33

You have a pointer to a CA object, so use the -> operator to access the CA members:

int n = instance->m_member;

--Mike--
"So where does that leave us? Well, it leaves us right back where we started, only more confused than before." -- Matt Gullett
Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabber

Re: How to get a sub-member's pointer

FlyingDancer13-Jun-03 19:14

FlyingDancer

13-Jun-03 19:14

I want to get the member's pointer, not its value.

Re: How to get a sub-member's pointer

Michael Dunn13-Jun-03 19:22

Michael Dunn

13-Jun-03 19:22

I don't know what you mean by "the member's pointer"

--Mike--
"So where does that leave us? Well, it leaves us right back where we started, only more confused than before." -- Matt Gullett
Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabber

Re: How to get a sub-member's pointer

Toni7813-Jun-03 19:27

Toni78

13-Jun-03 19:27

John M. Drescher already gave you the correct answer.

// Afterall I realized that even my comment lines have bugs

Re: How to get a sub-member's pointer

John M. Drescher14-Jun-03 4:42

John M. Drescher

14-Jun-03 4:42

Thanks. I had no clue how my answer could be wrong...

John

Re: How to get a sub-member's pointer

Brian Delahunty14-Jun-03 0:39

Brian Delahunty

14-Jun-03 0:39

What do you mean by the members pointer??? The members address???? A pointer to m_member???

instance->m_member; will get the value.

int* xyz = &(instance->m_member); will give a pointer to m_member.

&(instance->m_member); is the address of m_member in your instance of CA.

Regards,
Brian Dela Smile | :)

Re: How to get a sub-member's pointer

FlyingDancer14-Jun-03 1:12

FlyingDancer

14-Jun-03 1:12

Yeah, thank you!
Once a time I uesed "&(instance.m_member)" as a reference to the member.
As a result it was wrong(instance is an object). Then I replaced it with "(int *)instance.m_member", compiling is ok.
Maybe something else had been wrong.

Thank you again!
Blush | :O

Re: How to get a sub-member's pointer

Brian Delahunty14-Jun-03 1:21

Brian Delahunty

14-Jun-03 1:21

Your welcome.

Regards,
Brian Dela Smile | :)

FONT

Anthony988713-Jun-03 13:24

Anthony9887

13-Jun-03 13:24

I'm using the CreateFontDirect and trying to set the Point size of the height of the font and then display it. I'm using a map mode of MM_LOMETRIC, but the size is not the same as word diplays it. It works fine if the map mode is MM_TEXT.

Thanks

How to sync folders over the internet?

IGx8913-Jun-03 12:59

IGx89

13-Jun-03 12:59

I need to create a program that will keep a list of folders synchronized, on-demand, between a number (10+) of computers on the internet. At a function call, I need a computer to be able to connect to the other computers and find and download the latest version of a specific folder. It also needs to use as little bandwidth and CPU as possible, because the computers with be also running game servers (this progam will interface somewhat with the game server, also).

Now, how should I go about doing that? I have zero experience in any network programming, but with all the articles here, I don't think it would take me too long to learn. Currently, I'm considering having a small http server and a http file download client on each computer, since that seems the simplest.

Thanks!

Re: How to sync folders over the internet?

valikac13-Jun-03 15:12

valikac

13-Jun-03 15:12

One soluton is winsock. Design your own server/client for custom system file synchronization.

Kuphryn

Re: How to sync folders over the internet?

Brian Delahunty14-Jun-03 0:30

Brian Delahunty

14-Jun-03 0:30

This is not exactly what your looking for [and it is in C#] but it might give you some ideas:

http://www.codeproject.com/csharp/NET_FTP_Upload.asp[^]

Regards,
Brian Dela Smile | :)

Search Algorithims

Steven M Hunt13-Jun-03 12:21

Steven M Hunt

13-Jun-03 12:21

What's wrong with this function i used to find text in an edit control? I don't understand, it should work:
//CFindReplaceDialog FindDlg pre-defined
if (FindDlg->FindNext())
{
CString data;
GetDlgItemText(IDD_EDIT, data);
int FindIndex = data.Find(_T(FindDlg->GetFindString()), FindStart);//int FindStart global variable
if (FindIndex > -1)
{
FindStart = FindIndex + FindDlg->GetFindString().GetLength();
CEdit *edit = (CEdit *) GetDlgItem(IDD_EDIT);
MessageBox("testing...");
edit->SetSel(FindIndex, FindStart, FALSE);
}
else
{
MessageBox("The text you entered was not found.", "Text not found", MB_ICONINFORMATION);
}
}

What could be wrong with this code?

-- Steve

Re: Search Algorithims

Ryan Binns14-Jun-03 1:42

Ryan Binns

14-Jun-03 1:42

Make sure that FindStart has a valid value in it (set it to 0 or -1 and see if that helps).

The line
int FindIndex = data.Find(_T(FindDlg->GetFindString()), FindStart);
doesn't need the _T() (_T() is only used for string literals), but it won't make a difference unless you're compiling for unicode:
int FindIndex = data.Find(FindDlg->GetFindString(), FindStart);

Step through the code one line at a time and see what all your variables are after each statement. The code logic looks fine, so it should work.

Ryan

Being little and getting pushed around by big guys all my life I guess I compensate by pushing electrons and holes around. What a bully I am, but I do enjoy making subatomic particles hop at my bidding - Roger Wright (2^nd April 2003, The Lounge)

Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late - John Nichol "Point Of Impact"

Re: Search Algorithims

Steven M Hunt14-Jun-03 7:52

Steven M Hunt

14-Jun-03 7:52

It should work, and the toolbar responds that something is selected, but there is no selection and the edit control refuses to accept any messages. The cut, copy, and paste features in my program refuse to work after a search. I've never seen this problem before.

-- Steve

Problem with CreateWindowEx(..)! Please Help!

nutkase13-Jun-03 12:16

nutkase

13-Jun-03 12:16

Well,
while working on a class i am facing a really bad problem! well, i just cant get it!
i just run the following code

<br />
BOOL COpenGLWindow::CreateOpenGLWindow(RECT Rect,char* WindowCaption,bool Fullscreen,int Bits,UINT ExStyle,UINT Style,HWND Parent)<br />
{<br />
	WNDCLASS WndClass;<br />
	WndClass.style=CS_VREDRAW|CS_HREDRAW|CS_OWNDC;<br />
	WndClass.lpfnWndProc=OpenGLWndProc;<br />
	WndClass.cbClsExtra=0;<br />
	WndClass.cbWndExtra=0;<br />
	WndClass.hInstance=GetInstHandle();<br />
	WndClass.hIcon=::LoadIcon(NULL,IDI_WINLOGO);<br />
	WndClass.hCursor=::LoadCursor(NULL,IDC_ARROW);<br />
	WndClass.hbrBackground=0;<br />
	WndClass.lpszMenuName=0;<br />
	WndClass.lpszClassName="OpenGLClass";<br />
	if(!RegisterClass(&WndClass))<br />
	{<br />
		OutputDebugString();<br />
		return FALSE;<br />
	}<br />
	bool ShowWnd=(Style&WS_VISIBLE);<br />
	Style|=~WS_VISIBLE;<br />
	//AdjustWindowRectEx(&Rect,Style,FALSE,ExStyle);<br />
	if(!(hWnd=CreateWindowEx(ExStyle,"OpenGLClass",WindowCaption,Style,Rect.left,Rect.top,Rect.right-Rect.left,Rect.bottom-Rect.top,Parent,(HMENU)NULL,GetInstHandle(),NULL)))<br />
	{<br />
		OutputDebugString();<br />
		return FALSE;<br />
	}<br />
	if(!(hDC=GetDC()))<br />
	{<br />
		OutputDebugString();<br />
		return FALSE;<br />
	}<br />
	PIXELFORMATDESCRIPTOR pfd=<br />
	{<br />
		sizeof(PIXELFORMATDESCRIPTOR),<br />
		1,<br />
		PFD_DRAW_TO_WINDOW|PFD_SUPPORT_OPENGL|PFD_DOUBLEBUFFER,<br />
		PFD_TYPE_RGBA,<br />
		Bits,<br />
		0,0,0,0,0,0,0,0,0,0,0,0,0,<br />
		24,<br />
		0,0,0,0,0,0,0<br />
	};<br />
	int PixelFormat;<br />
	if(!(PixelFormat=ChoosePixelFormat(hDC,&pfd)))<br />
	{<br />
		OutputDebugString();<br />
		return FALSE;<br />
	}<br />
	if(!SetPixelFormat(hDC,PixelFormat,&pfd))<br />
	{<br />
		OutputDebugString();<br />
		return FALSE;<br />
	}<br />
	if(!(hRC=wglCreateContext(hDC)))<br />
	{<br />
		OutputDebugString();<br />
		return FALSE;<br />
	}<br />
	if(!wglMakeCurrent(hDC,hRC))<br />
	{<br />
		OutputDebugString();<br />
		return FALSE;<br />
	}<br />
	if(ShowWnd)<br />
	{<br />
		ShowWindow(hWnd,SW_SHOW);<br />
		SetForegroundWindow(hWnd);<br />
		SetFocus(hWnd);<br />
	}<br />
	return TRUE;<br />
}<br />

and the call to CreateWindowEx Failes ! GetLastError() prints INvalid Window Handle.?!?!?!? Confused | :confused:

well the call bieing made to this function is as follows:

<br />
CreateOpenGLWindow(Rect,"Mine",false,16,WS_EX_APPWINDOW|WS_EX_WINDOWEDGE,WS_POPUPWINDOW,NULL);<br />

WEll i m in serious trouble so please help as soon as possible!
shoaib.

Doesn't Window Really Sucks!

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