C / C++ / MFC Discussion Boards

VC++6, ODBC, and Access 2000

Roger Wright5-Jan-04 6:42

5-Jan-04 6:42

I've only worked with very simple DBs in C++/MFC to date, mostly having 1 table, but I've been having trouble with a 3-table DB for a couple of days. The App Wizard creates one recordset, accessed via m_pSet, which contains all fields from all tables. This opens the recordset well enough, but when I change the m_strFilter value and requery to find a match on fields in just one of the tables I get an error that isn't defined anywhere I can locate (Too few arguments - 2 expected). The requery is the call that causes the error; everything else appears to work fine up to that point.

Would it be simpler (and perhaps smarter) to construct separate recordsets for each table, and do this operation on just the one table? These tables don't have to be joined; it's a very simple DB.

"Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.

Re: VC++6, ODBC, and Access 2000

FieldHawk5-Jan-04 7:23

FieldHawk

5-Jan-04 7:23

U simply create ur application, without mentioning abt the
database support.
now create a new class whose base class is CRecordset.
and add the following header file #include "afxdb.h"
in the stdafx.h

Re: VC++6, ODBC, and Access 2000

Chris Meech5-Jan-04 7:26

Chris Meech

5-Jan-04 7:26

Roger Wright wrote:
but when I change the m_strFilter value and requery to find a match on fields in just one of the tables

Before changing the m_strFilter, what has it been set to? I'm thinking that you may be 'breaking' the joining of the tables of the original query. I'm going out on a limb here, but I think you probably need to a new query/recordset together to fit your needs. Typically the requery method is used where you've changed the value associated with parameters and require the recordset to be fill with new data. Since you need to only query one of the tables, I'd recommend building another recordset just for that query.

Chris Meech

It's much easier to get rich telling people what they want to hear. Christopher Duncan

I can't help getting older, but I refuse to grow up. Roger Wright

I've been meaning to change my sig. Thanks! Alvaro Mendez

We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton

Re: VC++6, ODBC, and Access 2000

Roger Wright5-Jan-04 7:50

Roger Wright

5-Jan-04 7:50

Chris Meech wrote:
I'm thinking that you may be 'breaking' the joining of the tables of the original query.

That's my thinking, as well. When I think of a recordset, I picture something like a spreadsheet that I can scroll thru selecting rows as needed. When the wizard creates the initial recordset, it binds all the fields from all tables, even though one may have a thousand records, and another 6. That's gotta break something. When my requery asks for a record from the one table containing the two fields of interest, there's no guarantee that the other two tables will have anything in that particular row, so something's got to give. Thanks for the tip.

"Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.

Re: VC++6, ODBC, and Access 2000

David Crow5-Jan-04 7:27

David Crow

5-Jan-04 7:27

In your CRecordset-derived class, make sure that the value of m_nFields matches exactly the number of RFX_xxx() calls in the DoDataExchange() method (these calls are preceded by a call to pFX->SetFieldType(CFieldExchange::outputColumn)). This number must also match the number of columns actually being retrieved from the SELECT statement.

Now as far as m_strFilter goes, you'll also need to make sure that the value of m_nParams matches the number of '?' in m_strFilter, and that they are in the same order as the corresponding RFX_xxx() calls in the DoDataExchange() method (these calls are preceded by a call to pFX->SetFieldType(CFieldExchange::param)).

Roger Wright wrote:
Would it be simpler (and perhaps smarter) to construct separate recordsets for each table, and do this operation on just the one table? These tables don't have to be joined; it's a very simple DB.

It's always better to not add unnecessary complexity to an application. If no JOINing is required, by all means don't do it!

A rich person is not the one who has the most, but the one that needs the least.

VC++ .NET 2002 and 2003 Pro

jdgonko5-Jan-04 6:26

jdgonko

5-Jan-04 6:26

I currently use the Visual C++ .NET 2002 Professional product.

Is it true that compiler optimizations are NOT available in this version??? They do appear to be grayed-out (disabled) in the project properties boxes. Confused | :confused:

PLUS, I'm considering upgrading to Visual C++ .NET 2003 Pro (their newest) BUT will only do so if compiler optimizations are then available. Does anyone know if this will be the case? Confused | :confused:

If I have to buy an "enterprise" version just to get compiler optimizations, I may be kicking the MS development environment off my PC!!! Poke tongue | ;-P

Re: VC++ .NET 2002 and 2003 Pro

abc8765-Jan-04 6:44

abc876

5-Jan-04 6:44

Hehe

thanks to software piracy!! I bought VS.NET 2003 enterprise for just $5
+ i have never bought any software > $5 Smile | :)

Muhammad Shoaib Khan
http://geocities.com/lansolution

Re: VC++ .NET 2002 and 2003 Pro

Chris Meech5-Jan-04 7:36

Chris Meech

5-Jan-04 7:36

M.Shoaib Khan wrote:
thanks to software piracy!! I bought VS.NET 2003 enterprise for just $5

And thanks to crooks like you, software prices stay inflated in order to pay for efforts to counter software piracy.

Sometimes I wonder why I bother ..... D'Oh! | :doh:

Chris Meech

It's much easier to get rich telling people what they want to hear. Christopher Duncan

I can't help getting older, but I refuse to grow up. Roger Wright

I've been meaning to change my sig. Thanks! Alvaro Mendez

We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton

Re: VC++ .NET 2002 and 2003 Pro

abc8765-Jan-04 7:55

abc876

5-Jan-04 7:55

Chris Meech wrote:
And thanks to crooks like you..

Excuse me!! i am not a dishonest person... Cry | :((

its not my responsibility... YOU WONT BE ABLE TO FIND LICENSED COPY OF ANY SOFTWARE IN PAKISTAN EASILY (MAY BE THEY ARE AVAILABLE) BUT I HAVENT SEEN ANY SINGLE SUCH SHOP OVER HERE..

its responsibility of software vendor to provide licensed software in easy approach.. not mine to search for a licensed version of CD in my part of world. and btw there are NO SOFTWARE LAWS in Pakistan as yet (coming in few years).. so its legal. huh

Dead | X|

Muhammad Shoaib Khan
http://geocities.com/lansolution

Re: VC++ .NET 2002 and 2003 Pro

Chris Meech5-Jan-04 8:15

Chris Meech

5-Jan-04 8:15

M.Shoaib Khan wrote:
... thanks to software piracy!! I bought VS.NET 2003 enterprise for just $5 + i have never bought any software > $5

... Excuse me!! i am not a dishonest person...

You admit purchasing stolen software and then claim to be an honest person. Your twisted logic escapes me. Confused | :confused:

Re: VC++ .NET 2002 and 2003 Pro

Nick Hodapp5-Jan-04 7:25

Nick Hodapp

5-Jan-04 7:25

The 2002 Professional product includes the optimizing compiler. The non-optimizing compiler is only shipped with the "Standard" edition, and the .NET Framework SDK.

Same for 2003 versions - "Professional" is what you need.

Which options are greyed out? What type of application are you building (.NET, Windows, .exe, .dll, etc.?)

Nick Hodapp

This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your use. © 2003 Microsoft Corporation. All rights reserved.

Re: VC++ .NET 2002 and 2003 Pro

Nick Hodapp5-Jan-04 7:28

Nick Hodapp

5-Jan-04 7:28

One other thing - at the command line you can determine if you have the optimizing or non optimizing compiler -- just type cl /? to see the banner. Mine reports:

Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 13.10.3052 for 80x86
Copyright (C) Microsoft Corporation 1984-2002. All rights reserved.

Nick Hodapp

This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your use. © 2003 Microsoft Corporation. All rights reserved.

Re: VC++ .NET 2002 and 2003 Pro

jdgonko5-Jan-04 7:43

jdgonko

5-Jan-04 7:43

My bad... Yes, it is the "standard" version unfortunately. Sleepy | :zzz:

Microsoft (R) 32-bit C/C++ Standard Compiler Version 13.00.9466 for 80x86
Copyright (C) Microsoft Corporation 1984-2001. All rights reserved.

Dern it!!

BTW, notice the d!psh!t bragging about piracy? What does she expect us to say?? Congratulations thief?!?

Probably a poor driver too who doesn't realize that her accidents raise the insurance rates for EVERYONE... Mad | :mad:

Bitmaps on Static Controls, How to ?

rpadrela5-Jan-04 6:05

rpadrela

5-Jan-04 6:05

// Load Process
HANDLE hBitmap;
hBitmap = ::LoadImage( GetModuleHandle( rvl_null ), pathFileName, IMAGE_BITMAP, 0, 0, LR_DEFAULTSIZE | LR_LOADFROMFILE );

m_pBitmaps[ i ].Attach( hBitmap ); // m_pBitmaps is an array of CBitmap

//////////////////////
CStatic* pImageCtrl = rvl_null;
pImageCtrl = ( CStatic* ) GetDlgItem( IDC_NEWMAP_DIALOG_IMAGE );

pImageCtrl->SetBitmap( HBITMAP( m_pBitmaps[ 0 ] ) );

I'm using this piece of code to place a bitmap inside a static control but it's not working as it should. What i'm doing wrong ?

PS: Bitmaps are loaded from file.

Thanks

Re: Bitmaps on Static Controls, How to ?

twing5-Jan-04 17:15

twing

5-Jan-04 17:15

You should pick Bitmap Type in Picture properties.

Hello World!

printing question

ns5-Jan-04 5:16

5-Jan-04 5:16

I didnt choose to enable print support when I created my project but now want to add it. Is it possible at this late stage or do I recreate from the start?
Thanks,
ns

Re: printing question

David Crow5-Jan-04 7:32

David Crow

5-Jan-04 7:32

You can add the necessary code at any point, but I would recommend creating a temporary project with AppWizard and copy the necessary code over to your current project. That way it will look like AppWizard created it from the start.

A rich person is not the one who has the most, but the one that needs the least.

Re: printing question

ns6-Jan-04 2:07

6-Jan-04 2:07

thanks. I guess I will have to windiff the files in the projects and see what gets added on....

Searching for a good screen saver tutorial

Cactus Joe015-Jan-04 4:48

Cactus Joe01

5-Jan-04 4:48

I've been looking around for a good tutorial on the basics of building a screen saver in C++ and without MFC.

I already have my EXE built; I just need to know how to make it work as an SCR. I know it needs to run in different modes like configure, test, preview, etc, but I don't know how to do this.

If anyone can point me to a good (or even semi-good) tutorial on this I would greatly appreciate it.

Thanks for your time.
-Cactus Joe

Re: Searching for a good screen saver tutorial

Prakash Nadar5-Jan-04 5:00

Prakash Nadar

5-Jan-04 5:00

MSDN samples contains full implementation of a screen saver.

Programming is an art not a skill, every one can be a skilled programmer but not an artist.

Re: Searching for a good screen saver tutorial

Cactus Joe015-Jan-04 8:28

Cactus Joe01

5-Jan-04 8:28

*Smacks forehead* D'Oh! | :doh:

Why did I not check there in first place...?

Thanks!

Hello!Dialog!

skylonely5-Jan-04 2:51

skylonely

5-Jan-04 2:51

I want to know how can I write a program based on Dialog Application, when it display another dialog, the dialog will fit the based dialog just like SDI/MDI's new files fitting in their parent window??? Cry | :((

Re: Hello!Dialog!

Iain Clarke, Warrior Programmer5-Jan-04 6:06

Iain Clarke, Warrior Programmer

5-Jan-04 6:06

You want something like...

BOOL CMyPopupDlg::OnInitDialog ()
{
   ...
   CWnd *pParent = GetParent (); // Gets the parent window / dialog   - try GetOwner if this doesn't work
   if (pParent)
   {
       CRect rc;
       pParent->GetWindowRect (&rc); // <-- NOT GetClientRect
       SetWindowPos (NULL, rc.left, rc.top, rc.Width (), rc.Height (), SWP_NOZORDER);
   }
   ...
   return CDialog::OnInitDialog ();
}

I hope that helps,

Iain.

Re: Hello!Dialog!

Prakash Nadar5-Jan-04 16:13

Prakash Nadar

5-Jan-04 16:13

i guess setting the child windows with WS_CHILD style will do the trick, didnt test it, but i guess thats what it is.

Programming is an art not a skill, every one can be a skilled programmer but not an artist.

Creating Evaluation copy

Abhi Lahare5-Jan-04 2:00

Abhi Lahare

5-Jan-04 2:00

Hi all,
I want to distribute my applications to others, but at the same time i want to make sure that it will run for the say N Days only. Can anyone give any direction to start. My application is Win32 Application and i am using MSVC 6.0

Thanks in advance.
AL

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