|
I want to write to an Access(*.mdb) file from a form(Record View) and capability to read this access file.
I did like MSDN and i have created a Recordset class and Record View class i have connect record view to Recordset but it does not work. how can i do this?
Mehdi Hosseinpour
|
|
|
|
|
For all database functionality on MFC, I first suggest you read the article by Stefan Chekanov found here[^].
The Access file acts as a data source, and by using Chekanov's article and the classes introduced there, you can execute plain SQL-queries to retrieve custom data sets, and then use a by-index or by-name methods to retrieve the data from the resulting set. After you have the data in a local variable (CString or similar), you can use Dialog Data Exchange implemented by a CFormView-derived class to move data into the form's controls and vice versa.
To write data into the database, use the Field function to get a reference to the CDBField, then use the overloaded assignment '=' operator in CDBField class. Remember to prepare the database for updates first, and then flush the update operations when finished. Otherwise an assertion might occur.
-Antti Keskinen
----------------------------------------------
The definition of impossible is strictly dependant
on what we think is possible.
|
|
|
|
|
Mehdi_Hosseinpour wrote:
...but it does not work.
Which means what? Are you getting compiler, linker, or runtime errors? Please elaborate.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
We can't help you if you don't give details!
Don't try it, just do it! 
|
|
|
|
|
What is the difference between platform SDK and service pack for visual C++?
which one should i choose for what ?
Thanx.
MSN Messenger.
prakashnadar@msn.com
Tip of the day of visual C++ IDE.
"We use it before you do! Visual C++ was developed using Visual C++"
|
|
|
|
|
As far as i know
Platform SDK is a set of header files, lib and other such stuff for developing windows application without any MFC or ATL.
Service Packs (for VC++) are generally for MFC, VB and data access(DAO,ADO)
C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
|
|
|
|
|
servicepack is a cumulative fixes for known bugs and problems.
sdk is a downloadable platform for developers. 
greatest thing is to do wot others think you cant
suhredayan@omniquad.com>
messenger :suhredayan@hotmail.com
|
|
|
|
|
Suhredayan P wrote:
servicepack is a cumulative fixes for known bugs and problems.
so microsoft is still fixing bugs in VC6 
MSN Messenger.
prakashnadar@msn.com
Tip of the day of visual C++ IDE.
"We use it before you do! Visual C++ was developed using Visual C++"
|
|
|
|
|
Well, SP5 is not that old. It's safe to say that they would only be concerned with critical issues (e.g., security, data integrity) at this point.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
Mr.Prakash wrote:
so microsoft is still fixing bugs in VC6
Nope, they barely support it anymore, as articles keep disappearing from MSDN. VS6SP5 was the last service pack released, and there won't be any more. The PSDK, however, gets a facelift every once in a while, and adds a huge list of functionality missing from the libraries shipped with VS6. Get both.
[EDIT]
I just scrolled down and discovered that SP6 was released yesterday. Yippee! Downloading now...
[/EDIT]
Will Build Nuclear Missile For Food - No Target Too Small
|
|
|
|
|
Uh oh, the service pack contains a few VSS related fixes only. 
<edit>
Ah, it's VSS SP6, not VC++ SP6. That would explain it!
</edit>
/ravi
My new year's resolution: 2048 x 1536
Home | Articles | Freeware | Music
ravib@ravib.com
|
|
|
|
|
Now that's confusing. You're right, the trail leads to a vss6sp6enu download from one path, but to vs6sp6 from another. The latter is 62MB, and is recommended for anyone using VC++6 with VSS, or VB6. I can't believe the fixes for VSS take up 62MB! Usually I like to check what fixes are included in a download, but the documentation links lead only to info about the VSS SP, not the one I just downloaded. Oh well, if it follows tradition there will be about 42 separate README files after I extract it. That should keep me entertained for a while.
Will Build Nuclear Missile For Food - No Target Too Small
|
|
|
|
|
i was pegging away at the keyboard and accidently wrote something like this
int i;
int j=0;
CRect rc;
rc.left = j,i;
(notice the , between j and i)
compiler shows no errors or warnings 
VC6, No service Packs
never seen or heard anything about this before
C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
|
|
|
|
|
mailMonty wrote:
(notice the , between j and i)
compiler shows no errors or warnings
Hey, that ',' is the comma-operator, and you did use it in a syntactically correct way. About what sould the compiler complain?
"We trained hard, but it seemed that every time we were beginning to form up into teams we would be reorganised. I was to learn later in life that we tend to meet any new situation by reorganising: and a wonderful method it can be for creating the illusion of progress, while producing confusion, inefficiency and demoralisation."
-- Caius Petronius, Roman Consul, 66 A.D.
|
|
|
|
|
jhwurmbach wrote:
that ',' is the comma-operator, and you did use it in a syntactically correct way
how is this syntactically correct? 
C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
|
|
|
|
|
mailMonty wrote:
how is this syntactically correct?
You are invoking the comma operator, basically returning only the value of the rightmost expression.
Consider this:
int i = 9;
int j=0;
int rc;
rc = j,i;
After this code fragment, rc has a value of 9.
A brief description is here[^], but google will give you any number of examples.
"We trained hard, but it seemed that every time we were beginning to form up into teams we would be reorganised. I was to learn later in life that we tend to meet any new situation by reorganising: and a wonderful method it can be for creating the illusion of progress, while producing confusion, inefficiency and demoralisation."
-- Caius Petronius, Roman Consul, 66 A.D.
|
|
|
|
|
Thanks 
Learned something new today, this can be good interview material 
C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg
|
|
|
|
|
mailMonty wrote:
Learned something new today,
Me too;)
I only had a vague idea what the comma operator does. Doing the test program and the googeling was brushing up my knowledge.
But in reality, I would consider use of the comma operator be bad style.
"We trained hard, but it seemed that every time we were beginning to form up into teams we would be reorganised. I was to learn later in life that we tend to meet any new situation by reorganising: and a wonderful method it can be for creating the illusion of progress, while producing confusion, inefficiency and demoralisation."
-- Caius Petronius, Roman Consul, 66 A.D.
|
|
|
|
|
Another "strange" thing that I stumbled across a few years back was that any code preceeding the #include <stdafx.h> statement is ignored if precompiled headers are being used.
"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)
|
|
|
|
|
Hi,
I created a table 2*2 rows and columns and i want to change the TD elemeent of a cell to TH element(Table header). But as all the elements under the TABLE object is read only I could't succeed. Plz help me to replace the cell which is TD Element to TH element.Thanx in advance...
Lokesh.K
|
|
|
|
|
keshjesh@sify.com wrote:
I created a table 2*2 rows and columns
How did you create it? using vc++
keshjesh@sify.com wrote:
Plz help me to replace the cell which is TD Element to TH element.Thanx in advance...
Can't you frontpage or something ?
MSN Messenger.
prakashnadar@msn.com
Tip of the day of visual C++ IDE.
"We use it before you do! Visual C++ was developed using Visual C++"
|
|
|
|
|
yes boss using VC++ only,
i want to do just want Frontpage does.I want to insert cell header.
CAN U HELP ME...
|
|
|
|
|
Hi all,
I'm testing some code and just created a simple mfc console app (using the wizard) in VC6.
I did a first build after project creation, without any change, and it worked ok. Then I've gone to the project's settings and in the C/C++ tab, in the general category, I added _UNICODE and removed _MCBS from the preprocessor definitions. That line now has the following:
_DEBUG,WIN32,_CONSOLE,_UNICODE,_AFXDLL
Now the problem is that after making a full rebuild, the output of the program is wrong: instead of displaying the "Hello..." string it displays the address of the text.
If I remove the _UNICODE define, all is ok. I've been testing and found out the following:
cout << "Test" << endl;
outputs: Test
cout << L"Test" << endl;
outputs: 0041401C
cout << _T("Test") << endl;
outputs: 0041401C
I thought that cout was unicode compliant...
What the ... am I doing wrong?
TIA
|
|
|
|
|
yes, cout accepts only byte stream.
once u compile as unicode ur "Test" is defined as multi stream and is not displayed correctly.
greatest thing is to do wot others think you cant
suhredayan@omniquad.com>
messenger :suhredayan@hotmail.com
|
|
|
|
|
Thanks for the tip...
So, the best way to deal with it is just to use _tprintf() and similar and forget about cout, right? This way I don't need to worry if I'm using Unicode or not.
Not a big problem, as this is just a test application.
But, just for curiosity, is there nothing in stl that can output unicode strings?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
