C / C++ / MFC

Re: Application hangs when interrupted

5-Feb-06 5:46

I have written a few applications in VC++ 2003 that access database information via ODBC. The typical application makes various SQL requests and displays the results in a Single Document CListView, using the report style.

The programs seem to execute fine as long as they have complete focus with uninterrupted processing time. If I try to minimize the window or check my Outlook email or use some other application while the database application processes some lengthy data retrievals, the database application hangs up.

Any ideas or suggestions to make the program work more efficiently?

Thanks for any comments!

Message Closed

5-Feb-06 8:44

ddmcr

5-Feb-06 8:44

Message Closed

Joel McAlduff5-Feb-06 8:56

Retrieving data from an ODBC data source

5-Feb-06 8:56

Thanks! I had a feeling I might be headed in the direction of using threads.

SWDevil5-Feb-06 4:26

5-Feb-06 4:26

Hi,

I need to write an application that:
1. opens a database (I connect through ODBC)
2. retrieves data from a table, using an SQL query
3. enters the retrieved data into a table in a different database

So far, I wrote the following code for steps 1 and 2:

CDatabase srcDb;
if (srcDb.Open(NULL))
{
m_sDbName = srcDb.GetConnect(); //m_sDbName is a variable of type CString
UpdateData(FALSE);
}

CRecordset rs(&srcDb);
CString strSQL;
strSQL = "SELECT * FROM table1";

rs.Open(CRecordset::snapshot, strSQL, CRecordset::readOnly);
rs.Close();

Everything works OK, (the database is connected), but when it gets to the row:
rs.Open(CRecordset::snapshot, strSQL, CRecordset::readOnly);
the application crashes, and I don't understand why...

Is this the right syntax for connecting to a database and retrieving data from a table? Can someone maybe attach some source code, so I could compare...

Another question - after the row: rs.Open(CRecordset::snapshot, strSQL, CRecordset::readOnly); is executed, how do I read the data that was retrieved by the SQL query? is it in the recordset object?

Note: I am using Visual C++ 2003.

Joel McAlduff5-Feb-06 4:44

5-Feb-06 4:44

Seems like you are doing something similar, but this code works for me throughout my appliations that connect to databases via ODBC. I'm also using VC++ .Net 2003.

rs.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL,CRecordset::none);

SWDevil5-Feb-06 4:52

5-Feb-06 4:52

ok - but how do I see/read the data that I retrieved with the query?

And could you maybe write the rest of your sourcecode - how did you connect to the database, how do you read the data from the query?

Thanks Smile | :)

Joel McAlduff5-Feb-06 5:22

5-Feb-06 5:22

Here is a simple example. I left out A LOT of defensive coding to keep it short. Usually I am connecting to a single database within SQL server or Oracle, so I like to do this once and keep the connection open for the duration the application is active. Thus, I use a pointer to the database object and allocate memory for this with the new command (followed by a delete command later). I am usually in and out of recordsets so I tend to just create these objects within the functions that use them.

// Create and Open the Database via ODBC
CString strDSN = "DSN=The_DomainServiceName_Here; UID=User_ID_Here; PWD=Password_Here";
CDatabase* m_pDB;
m_pDB = new CDatabase;
m_pDB->OpenEx(strDSN,CDatabase::openReadOnly);

// Create and Open a Recordset connected to the database above
CString str, strMessage;
CRecordset rs(m_pDB);
str = "SELECT SOME_FIELDS FROM SOME_TABLES WHERE BLAH BLAH... ";
rs.Open(AFX_DB_USE_DEFAULT_TYPE,str,CRecordset::none);

while (!rs.IsEOF())
{
rs.GetFieldValue("FIELD_NAME1",str);
strMessage += str;
rs.GetFieldValue("FIELD_NAME2",str);
strMessage += " ";
strMessage += str;
rs.MoveNext();
}

AfxMessageBox(strMessage);

rs.Close();

m_pDB->Close();
delete m_pDB;
m_pDB = NULL;

Hope this helps.

SWDevil5-Feb-06 20:55

5-Feb-06 20:55

Ok - thanks, it helped, but just a few questions:

1. I need to do the connection to the database from one function (when a user presses a certain button) and open the recordset in another function (when the user presses another button). How do I do this? make the CDatabase object global (a member variable)? Also, I want to get the strDSN string information from the user by opening a dialog box and letting him choose a data source. Again, how do I do this? Smile | :)

2. can I read the data from the records somehow else - not to a string?

3. does my class (in which I am doing all of this db handling) have to inherit from CRecordset?

3. what did you mean by: "I left out A LOT of defensive coding" ?

David Crow7-Feb-06 2:54

David Crow

7-Feb-06 2:54

SWDevil wrote:
...the application crashes, and I don't understand why...

Have you stepped into the Open() call to find out why?

SWDevil wrote:
Another question - after the row: rs.Open(CRecordset::snapshot, strSQL, CRecordset::readOnly); is executed, how do I read the data that was retrieved by the SQL query? is it in the recordset object?

Derive a class from CRecordset. Its member variables will hold the vales. Otherwise, using CRecordset directly will require you to use GetFieldValue().

"The greatest good you can do for another is not just to share your riches but to reveal to him his own." - Benjamin Disraeli

SWDevil7-Feb-06 5:25

7-Feb-06 5:25

yeah - I tried stepping through the code..
But now I sometimes get an error saying that columns were not bound. do you know what that means?

About the recordset - what member variables hold the values? I looked at the MSDN help and could not see any variables that actually hold any data...

Visual Studio 2005 Standard - MFC?

David Crow7-Feb-06 5:34

David Crow

7-Feb-06 5:34

SWDevil wrote:
About the recordset - what member variables hold the values? I looked at the MSDN help and could not see any variables that actually hold any data...

ClassWizard creates them.

"The greatest good you can do for another is not just to share your riches but to reveal to him his own." - Benjamin Disraeli

Dominik Reichl5-Feb-06 2:08

Dominik Reichl

5-Feb-06 2:08

Hello!

Does Visual Studio 2005 Standard[^] support MFC and ATL?

If so, can the MFC libraries be statically linked to the application in the Standard edition?

Can I still develop native MFC applications, that don't use any of the .NET stuff?

Thanks in advance and best regards
Dominik

_outp(0x64, 0xAD);
and
__asm mov al, 0xAD __asm out 0x64, al
do the same... but what do they do??
(doesn't work on NT)

Re: Visual Studio 2005 Standard - MFC?

Jack Puppy5-Feb-06 3:21

Jack Puppy

5-Feb-06 3:21

Yes to MFC support.
Yes to ATL support.
Yes to MFC static linkage.
Yes to MFC without .NET.

"My dog worries about the economy. Alpo is up to 99 cents a can. That's almost seven dollars in dog money" - Wacky humour found in a business magazine

Detecting flash animation and pop-ups

llp00na5-Feb-06 2:01

llp00na

5-Feb-06 2:01

Deal All,

In my project I am processing web pages. I want to know the different components of a web page.

I know that it is possible to extract html elements (tables, divs, images ...) using the html DOM tree. But I am not sure if its possible to recognise flash animation and pop-ups (dynamic elements) within a certain web page.

Does any one know if this is feasible or not? if it is so, can you please advise me on this task.

Thank you

llp00na

Rotation text

duvaft4-Feb-06 23:08

duvaft

4-Feb-06 23:08

Can you help me abuot the text rotation like the behaviour in InDesign (text and cursor rotated).
Can yuo send me an example?
If the text is rotate also the cursor will be rotated.

Thanks. D'Oh! | :doh:

Eugene Pustovoyt5-Feb-06 0:21

Eugene Pustovoyt

5-Feb-06 0:21

Where do you want rotate text (screen, control and etc.)?

Best regards,
Eugene Pustovoyt

ICQ UIN: 161325180

EXTEIDE5-Feb-06 1:23

EXTEIDE

5-Feb-06 1:23

following is the CreateFontIndirect example in msdn.

HFONT FAR PASCAL MyCreateFont( void )
{
   CHOOSEFONT cf;
   LOGFONT lf;
   HFONT hfont;

   // Initialize members of the CHOOSEFONT structure.

   cf.lStructSize = sizeof(CHOOSEFONT);
   cf.hwndOwner = (HWND)NULL;
   cf.hDC = (HDC)NULL;
   cf.lpLogFont = &lf;
   cf.iPointSize = 0;
   cf.Flags = CF_SCREENFONTS;
   cf.rgbColors = RGB(0,0,0);
   cf.lCustData = 0L;
   cf.lpfnHook = (LPCFHOOKPROC)NULL;
   cf.lpTemplateName = (LPSTR)NULL;
   cf.hInstance = (HINSTANCE) NULL;
   cf.lpszStyle = (LPSTR)NULL;
   cf.nFontType = SCREEN_FONTTYPE;
   cf.nSizeMin = 0;
   cf.nSizeMax = 0;

   cf.lfOrientation = 180; // specify angle that you want.

   // Display the CHOOSEFONT common-dialog box.

   ChooseFont(&cf);

   // Create a logical font based on the user's
   // selection and return a handle identifying
   // that font.

   hfont = CreateFontIndirect(cf.lpLogFont);
   return (hfont);
}

Enjoy Rose | [Rose]

Anderson Sheen (exteide@gmail.com)
The Extension IDE: http://www.exteide.com

Eugene Pustovoyt5-Feb-06 2:14

Eugene Pustovoyt

5-Feb-06 2:14

Try this:

cf.lfEscapement = cf.lfOrientation = 180; // specify angle that you want.

Best regards,
Eugene Pustovoyt

ICQ UIN: 161325180

EXTEIDE5-Feb-06 3:41

EXTEIDE

5-Feb-06 3:41

right. i've sold out lfEscapement. Big Grin | :-D

Anderson Sheen (exteide@gmail.com)
The Extension IDE: http://www.exteide.com