C / C++ / MFC Discussion Boards

First Prev Next

Re: Error in GetFieldValue()

Bret Faller13-Aug-01 8:33

Bret Faller

13-Aug-01 8:33

SQL automatically makes column 0 the bookmark column (which is useless unless you're using bookmarks). Start your column numbers at 1.

Bret Faller
Odyssey Computing, Inc.

Re: Error in GetFieldValue()

Tomas13-Aug-01 8:54

Tomas

13-Aug-01 8:54

Thank you Bret.

This is not the solution.

I start with 1 and the error is "The index is not valid or the field name is incorrect".

I think the problem is another but I have no idea.

Tomás

Re: Error in GetFieldValue()

Bret Faller13-Aug-01 9:02

Bret Faller

13-Aug-01 9:02

Are you using a snapshot or dynaset recordset?

Bret Faller
Odyssey Computing, Inc.

Re: Error in GetFieldValue()

Tomas13-Aug-01 9:20

Tomas

13-Aug-01 9:20

I am using...

In the constructor:
m_nDefaultType = dynaset;

And to open:
rs.Open(CRecordset::forwardOnly,_T("SELECT COUNT(*) FROM mytable"),CRecordset::readOnly);

Re: Error in GetFieldValue()

Bret Faller13-Aug-01 11:04

Bret Faller

13-Aug-01 11:04

Actually, the anonymous guy is correct. You should use GetRecordCount(). And I believe the reason the other doesn't work is because I think the GetFieldValue gets a column value rather than a returned recordset value. So just do a plain open with a NULL query in order to get the whole recordset then do a GetRecordCount.

Bret Faller
Odyssey Computing, Inc.

Re: Error in GetFieldValue()

13-Aug-01 9:56

Seems like you just want the number of records in the database, so why don't you use the CRecordset::GetRecordCount() function.
Confused | :confused:

Re: Error in GetFieldValue()

Tomas13-Aug-01 12:01

Tomas

13-Aug-01 12:01

Yes this is a solution, but too slowly because you need to check all the recordset to know the number of records.

MoveFirst();
DoWhile(IsBof()) {
MoveNext();
count++;
}

Is more eficient to do a SELECT COUNT(*) rather a DoWhile().

Tomás

Re: Error in GetFieldValue()

14-Aug-01 12:27

No. You don't check it like this.

For example:

let's say you have a class CMyRecordset derived from CRecordset, and you use the default SQL, once you open the your RS class all you have to do is this..

CMyRecordset rs(db);
long lNumOfRecords;
rs.Open();
// if opens without any problem..
// this should give you the number of records you are looking for..
lNumOfRecords = rs.GetRecordCount();

Confused | :confused:

What does this function do?

Bret Faller13-Aug-01 8:13

Bret Faller

13-Aug-01 8:13

Good day,

Does anyone know what exactly GetSuperWndProc() does? I keep getting this as an unresolved external in my embeddedVC program even though I never call it. If I override it it will compile fine but crashes on execution. I was wondering if anyone knows what its supposed to do so that I can implement it. Thanks.

Bret Faller
Odyssey Computing, Inc.

Re: What does this function do?

Anders Molin13-Aug-01 8:42

Anders Molin

13-Aug-01 8:42

Are you using any thirdparty libraries?

I don't think it a standard API function. I have never seen it before, and a search on all of MSDN don't get anything...

- Anders

Money talks, but all mine ever says is "Goodbye!"

Re: What does this function do?

Bret Faller13-Aug-01 8:44

Bret Faller

13-Aug-01 8:44

Sorry, my bad, its GetSuperWndProcAddr(). But no, I'm not using any third party libraries. In MSDN it says its obsolete and I don't need to override it but for some reason eVC keeps telling me its an unresolved external in all of my View classes and in my FrameWnd.

Bret Faller
Odyssey Computing, Inc.

Re: What does this function do?

Anders Molin13-Aug-01 9:21

Anders Molin

13-Aug-01 9:21

Hmmm, strange...

Anyway, you can read a lot about errors with GetSuperWndProcAddr here

- Anders

Money talks, but all mine ever says is "Goodbye!"

SQLConfigDataSource

13-Aug-01 8:12

Hi there,

I am trying to create a SQL Server DSN using SQLConfigDataSource. Everything
seems ok, except for I can't figure out how to set the password part, to Windows Authentication as opposed to SQL Server Authentication. It appears that the latter one is the default and everytime I run my code it gets set to SQL Server Authentication.

thanks

Re: SQLConfigDataSource

Unforgiv3n11-Feb-10 0:56

Unforgiv3n

11-Feb-10 0:56

add

\0TRUSTED_CONNECTION

to your

SQLConfigDataSource

attributes

LockWindowUpdate with CHtmlView

ov13-Aug-01 7:23

13-Aug-01 7:23

I need to prevent my control's drawing while it is loading the page. I'm doing it this way:

In OnBeforeNavigate2():

LockWindowUpdate();

In OnDocumentComplete2():

UnlockWindowUpdate();

And in OnEraseBkgnd():

return true;

That works fine except the one moment: after the page was loaded - my desktop is redrawing. I don't understand why is it do this... It haven't web-style. The running ie doesn't redrawing it's page, but desktop is flickering.

How can I suppress it?

With the best regards, Vitaly.

question about focus

13-Aug-01 7:22

I have a dialog box with many different controls and an ok button.
the ok button has focus when starting the dialog.
I have set focus to other controls in the init of the dialog.
the other controls get focus i can type in them but the ok button has focus also and if the enter key is pressed at anytime the dialog exists.
Is there a way that i can stop this from happening?

Re: question about focus

13-Aug-01 7:54

Trap the KeyDown message (in PreTranslateMessage method) and on VK_RETURN set the focus according to your need.

Re: question about focus

Michael Dunn13-Aug-01 8:17

Michael Dunn

13-Aug-01 8:17

Just to clarify - OK doesn't keep the focus, but it is the default button (that's one of the button styles), so pressing ENTER triggers that button.

--Mike--
http://home.inreach.com/mdunn/
A recent survey reports that 1/4 of all internet users in England surf for porn.
The other 3/4 just didn't want to admit it.

Converting 'Integers to Strings' and 'Strings to Integers'

James Bird13-Aug-01 6:22

James Bird

13-Aug-01 6:22

Hi!

Does anyone know how to convert:

1. An integer to a string
2. A string to an integer

I know you can do this in Borland Delphi (IntToStr(), StrToInt()) so I wondered if it is possible to do the same in Visual C++...
Any help would be greatly appreciated... Smile | :)

James Bird - birdjames@bigfoot.com

Re: Converting 'Integers to Strings' and 'Strings to Integers'

Erik Thompson13-Aug-01 6:27

Erik Thompson

13-Aug-01 6:27

itoa() int to string
atoi() string to int

both are part of stdlib.h

Cheers,
-Erik
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
My thoughts are my own and reflect on no other.

Re: Converting 'Integers to Strings' and 'Strings to Integers'

Jamie Nordmeyer13-Aug-01 6:43

Jamie Nordmeyer

13-Aug-01 6:43

Integer to a string, use itoa, ltoa, or ultoa:

char str[4]; //Number of digits you might take + 1 for null char (in this case, 999 is max)

itoa(number, str, 10); //10 is the radix; 10 for decimal, 8 for octal, 16 for hex, 2 for binary

String to an integer, use atoi or atol:

int i=atoi("12");

Jamie Nordmeyer
Portland, Oregon, USA

Re: Converting 'Integers to Strings' and 'Strings to Integers'

CodeGuy13-Aug-01 10:58

CodeGuy

13-Aug-01 10:58

Also, if you are using std::string (which by the way is a lot easier to deal with than char arrays), you can use std::stringstream for your conversions. The nice thing, too, is that if you know how to use cout, then you can use stringstream. It can handle ints, floats, whatever.

#include <string>
#include <sstream>
#include <iostream>

using namespace std;

int main()
{
int i = 1;
float f = 2.0;
stringstream ss;
ss << "Let's print some numbers: " << i << "\t" << f;
string s = ss.str();

cout << s << endl;
return 0;
}

The output is:
Let's print some numbers: 1 2.0

Re: Converting 'Integers to Strings' and 'Strings to Integers'

CodeGuy13-Aug-01 11:01

CodeGuy

13-Aug-01 11:01

Whoops, btw, the three #includes that got deleted were for string, iostream and sstream. Darn these HTML tags.

draw line in rich edit

13-Aug-01 6:20

I am using the rich edit control to preview a report.
I have every just the way i want it execpt, i can not figure out how to draw a line(to separtate the header from the body)

Thank you anyone.

Re: draw line in rich edit

James Bird13-Aug-01 6:38

James Bird

13-Aug-01 6:38

My guess would be to calculate where abouts on the rich edit control the line has to go, and then draw using its dc:

int x = 2; // X = X Position Of Line In The Richedit Control
int y = 20; // Y = Y Position Of Line In The Richedit Control
int xs = 200; // XS = Size Of The Line (Horizontal)

CRichEditCtrl m_richedit;
CDC pDC = m_richedit.GetDC();
pDC.MoveTo(x, y);
pDC.LineTo(xs, y);
...

Hope this helps,

James Bird - birdjames@bigfoot.com

Last Visit: 31-Dec-99 18:00 Last Update: 14-May-24 11:01

Refresh

ᐊ Prev 1...18086 18087 18088 180891809018091 18092 18093 18094 18095 Next ᐅ

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