C / C++ / MFC Discussion Boards

moodsey21124-Jun-06 22:06

24-Jun-06 22:06

Can anyone show me how to update, delete, and add a record in a MS access database using CRecordset class without inheriting it.

thanks...

---------------------------Life is simple, you just complicate things-----------------------

Re: CRecordset problem

ovidiucucu25-Jun-06 1:30

ovidiucucu

25-Jun-06 1:30

For UPDATE, DELETE, and INSERT statements you don't need even CRecordset.
Can directly call CDatabase::ExecuteSQL, like for example:

class CFoo
{
// ...
   CDatabase m_db;
};
void CFoo::SomewhereInSpace()
{
   TRY
   {
      m_db.ExecuteSQL(_T("UPDATE Cats SET Name='Kitty' ")
                      _T("WHERE OwnerName='James'"));
   }
   CATCH(CDBException, e)
   {
      e->ReportError();
   }
   END_CATCH
}

Ovidiu Cucu
Microsoft MVP - Visual C++

Re: CRecordset problem

ovidiucucu25-Jun-06 2:18

ovidiucucu

25-Jun-06 2:18

... and if you want to use CRecordset (for SELECT statements, no way, you must do it), instantiate a CRecordset object (no need to derive) the call CRecordset::Open, and so on.

See example below

TRY
{
   CRecordset rs(&m_db);
   rs.Open(CRecordset::forwardOnly,
           _T("SELECT Name, OwnerName FROM Cats"));
   while(!rs.IsEOF())
   {
      const int nFieldsCount = rs.GetODBCFieldCount();
      for(int nFieldIndex = 0; nFieldIndex < nFieldsCount; nFieldIndex++)
      {
         // next field
         CDBVariant dbvarValue;
         rs.GetFieldValue(nFieldIndex, dbvarValue);
         // enjoy of field value...
      }
      rs.MoveNext(); // next record set row
   }
   rs.Close();
}
CATCH(CDBException, e)
{
   e->ReportError(); // see what's going wrong
}
AND_CATCH(CMemoryException, e)
{
   e->ReportError(); // see what's going wrong
}
END_CATCH

Ovidiu Cucu
Microsoft MVP - Visual C++

Help! How to add combobox into a listctrl ?

xjbetter24-Jun-06 21:51

xjbetter

24-Jun-06 21:51

I need to add combobox into a listctrl as a subitem . how to do it?

Re: Help! How to add combobox into a listctrl ?

ovidiucucu25-Jun-06 1:44

ovidiucucu

25-Jun-06 1:44

Check out this good article: Editable Table Control. [^]

Ovidiu Cucu
Microsoft MVP - Visual C++

Re: Help! How to add combobox into a listctrl ?

Hamid_RT25-Jun-06 1:53

Hamid_RT

25-Jun-06 1:53

See XListCtrl - A custom-draw list control with subitem formatting[^]

whitesky

visual studio 2005 problem with converting strings

cv_k3n24-Jun-06 19:45

cv_k3n

24-Jun-06 19:45

Hi, i just upgraded from visual studio 6 to visual studio 2005. The problem here is that i get this error message whenever i try to create a simple AfxMessageBox.

"error C2665: 'AfxMessageBox' : none of the 2 overloads could convert all the argument types"

I realise that if i do it like this,

AfxMessageBox((CString)"Something");

it will work. In the previous version there is no need for the '(CString)' part. Is it really meant to be like this in this new version or am i missing something here?

Re: visual studio 2005 problem with converting strings [modified]

Stephen Hewitt24-Jun-06 19:50

Stephen Hewitt

24-Jun-06 19:50

Don't go around casting. Use this:

AfxMessageBox(_T("Something"));

The _T (from <tchar.h> ) is a macro which makes the string MBCS or UNICODE depending on what your build is targeting.

Steve

Re: visual studio 2005 problem with converting strings

cv_k3n24-Jun-06 20:03

cv_k3n

24-Jun-06 20:03

Thanks a bunch. May i also know why this happens for the new version(2005) and not the old one(v 6)?

Re: visual studio 2005 problem with converting strings [modified]

Stephen Hewitt24-Jun-06 20:07

Stephen Hewitt

24-Jun-06 20:07

If you make a project in MSVC6 and look at the compiler settings you'll see that it has the _MBCS defined. With Visual Studio 2005 instead of _MBCS UNICODE and _UNICODE are defined. The default for MSVC6 projects is to use multibyte strings but for 2005 it is Unicode.

Steve

Re: visual studio 2005 problem with converting strings

cv_k3n24-Jun-06 20:36

cv_k3n

24-Jun-06 20:36

Thanks again Steve. As you can see, i'm fairly new to programming with visual studio. I'm having another problem with writing to files. Like before, this code works perfectly well in MSVC6 but its giving me problems in VS2005. I'll only show half the code for simplicity.

CString tempbuf;
tempbuf = "Job number,";
file.Write((LPCTSTR)tempbuf,tempbuf.GetLength());
file.Close;

When i open the file, it has 'J o b n u' in it. Do you know how i can fix this problem?

Thanks for your time.

Re: visual studio 2005 problem with converting strings [modified]

Stephen Hewitt24-Jun-06 21:24

Stephen Hewitt

24-Jun-06 21:24

The problem here is that you want to write the file in ANSI but you're compiling for Unicode. There are two ways you can go:
- Convert the Unicode string before writing.
- Change the project from Unicode to MBCS.

To make the second select "Project->Settings" and select the "C/C++" tab. Now erase the ~~"_MSBS"~~ "_MBCS" from the "Preprocessor definitions" edit box and add "UNICODE, _UNICODE" in its place. These steps are for MSVC6 but you should be able to adapt them.

Steve

-- modified at 4:14 Sunday 25th June, 2006

Re: visual studio 2005 problem with converting strings

cv_k3n24-Jun-06 22:05

cv_k3n

24-Jun-06 22:05

I couldn't find 'settings' in 'Project'. So the way i did it was i right-clicked the project node in Solution Explorer and clicked Properties.

There, i went to "Configuration Properties->C/C++->Preprocessor". I think it should be the same but they only had "WIN32;_WINDOWS;_DEBUG"

in the "Preprocessor definitions" edit box. I tried to add "UNICODE,_UNICODE" but it still didn't solve the problem.

Re: visual studio 2005 problem with converting strings

Stephen Hewitt24-Jun-06 22:09

Stephen Hewitt

24-Jun-06 22:09

Sorry, I got that the wrong way:
Remove "UNICODE,_UNICODE" and add "_MBCS".

Steve

Re: visual studio 2005 problem with converting strings

cv_k3n24-Jun-06 23:25

cv_k3n

24-Jun-06 23:25

I believe that my interface is slightly different from yours. First of all, in the preprocessor definitions box, there isn't any "UNICODE,_UNICODE". Whats there is: "WIN32;_WINDOWS;_DEBUG".

BUT, when i clicked on the "..." button at the right hand side of the box, there is a checkbox saying "Inherit from parent or project defaults" and a box that lists the inherited values: "_AFXDLL,UNICODE,_UNICODE".
I unchecked this box and added "_AFXDLL" and "_MBCS" to the original list of preprocessor definitions.

The list now looks like this: "WIN32;WINDOWS;_DEBUG;_AFXDLL;_MBCS;$(NOINHERIT)"

Now when i compile, this error comes up:

msvcrtd.lib(wcrtexew.obj) : error LNK2019: unresolved external symbol _wWinMain@16 referenced in function ___tmainCRTStartup

Re: visual studio 2005 problem with converting strings

Stephen Hewitt24-Jun-06 23:32

Stephen Hewitt

24-Jun-06 23:32

I haven't got VS2005 so I can't help you any further, sorry. Someone as CP must know how to change a Unicode project to MBCS using VS2005. Good luck.

Steve

Re: visual studio 2005 problem with converting strings

cv_k3n25-Jun-06 0:15

cv_k3n

25-Jun-06 0:15

Its ok.. What about your 1st solution: convert the unicode string before writing?

How can i do that?

Re: visual studio 2005 problem with converting strings

Stephen Hewitt25-Jun-06 0:22

Stephen Hewitt

25-Jun-06 0:22

Try this:

CT2CA(static_cast<LPCTSTR>(str))

See here[^] for details.

Steve

Re: visual studio 2005 problem with converting strings

Michael Dunn25-Jun-06 7:52

Michael Dunn

25-Jun-06 7:52

You need to read up on the differences between MBCS and Unicode. Start here: clickety[^]

--Mike--
Visual C++ MVP Cool | :cool:

LINKS~! Ericahist | PimpFish | CP SearchBar v3.0 | C++ Forum FAQ

VB > soccer

why is a virus, my pe file?

zon_cpp24-Jun-06 19:31

zon_cpp

24-Jun-06 19:31

hello!
i change header of a pe file and i add a new section for this file. this file execute correct and no problem. but kaspersky (anti virus) detect this file as a type_win32 virus!!!
why??? Cry | :((

Zo.Naderi-Iran

Re: why is a virus, my pe file? [modified]

Stephen Hewitt24-Jun-06 19:52

Stephen Hewitt

24-Jun-06 19:52

I would guess it interprets the file beging edited as an attack. This in understandable as this is the kind of trick a virus would use.

Steve

Re: why is a virus, my pe file?

Ted Ferenc24-Jun-06 21:46

Ted Ferenc

24-Jun-06 21:46

Virus checkers can give false positives, they are not 100% correct

I had one that claimed an empty directory was a virus, it was Microsoft's latest, once the 'fault' was reported they fixed their virus checker!

"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for - in order to get to the job you need to pay for the clothes and the car, and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman

Return the Caption of Windows

Max++24-Jun-06 18:06

Max++

24-Jun-06 18:06

What's the function that return the caption of the windows that is focusing in the system.

Re: Return the Caption of Windows

Michael Dunn24-Jun-06 18:23

Michael Dunn

24-Jun-06 18:23

GetFocus() returns the HWND of the window with the focus, if there is one. GetWindowText() returns its text.

--Mike--
Visual C++ MVP Cool | :cool:

LINKS~! Ericahist | PimpFish | CP SearchBar v3.0 | C++ Forum FAQ

VB > soccer

Re: Return the Caption of Windows [modified]

Stephen Hewitt24-Jun-06 19:29

Stephen Hewitt

24-Jun-06 19:29

If you want the window that has focus in the entire system GetFocus will not do the trick. To quote MSDN:
"GetFocus returns the window with the keyboard focus for the current thread's message queue. If GetFocus returns NULL, another thread's queue may be attached to a window that has the keyboard focus. "

If you want the window with focus in the whole system and not just the calling thread (and threads that have been attached to it through the AttachThreadInput function) you can do so through the GetGUIThreadInfo API. i.e.

GUITHREADINFO gti;
bti.cbSize = sizeof(GUITHREADINFO);
if (GetGUIThreadInfo(NULL, >i))
{
    HWND hFocus = gti.hwndFocus;
}

I don't think this works on 95 (does on 98) however.

Steve

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