Re: Why I cannot have a ListControl in a CRecordView derived class? - C / C++ / MFC Discussion Boards

Re: Why I cannot have a ListControl in a CRecordView derived class?

David Crow3-Dec-09 15:58

David Crow

3-Dec-09 15:58

If your query is joining multiple tables, it cannot be updated (i.e., read-only).

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

Re: Why I cannot have a ListControl in a CRecordView derived class?

Larry Mills Sr4-Dec-09 2:51

Larry Mills Sr

4-Dec-09 2:51

So how do I update, ie Read, Write or delete an individual table's record. Do I have to create a DSN for each table or what?

A C++ programming language novice, but striving to learn

Re: Why I cannot have a ListControl in a CRecordView derived class?

David Crow4-Dec-09 7:48

David Crow

4-Dec-09 7:48

Larry Mills Sr wrote:
So how do I update, ie Read, Write or delete an individual table's record.

Yes. Those tables should all be linked together via a primary/foreign key.

Larry Mills Sr wrote:
Do I have to create a DSN for each table or what?

No, but you may end up with several recordset classes.

Re: Why I cannot have a ListControl in a CRecordView derived class?

Larry Mills Sr4-Dec-09 8:02

Larry Mills Sr

4-Dec-09 8:02

David,
I don't understand your response. The tables are all loaded, but I cannot write or delete any records in them. How exactly do I write to one of the tables to add a new record? How dom I set CanUpdate() and CanAppend() to TRUE.
Nowhere in the Wizzard supplied Recordset class is there an "Open(....)" statement so I can change anything, so just how do I get to write tothe database?

A C++ programming language novice, but striving to learn

Re: Why I cannot have a ListControl in a CRecordView derived class?

David Crow4-Dec-09 9:06

David Crow

4-Dec-09 9:06

Larry Mills Sr wrote:
...but I cannot write or delete any records in them

Make sure the DSN, the CDatabase object, and the CRecordset object are all opened correctly (i.e., non read-only).

Larry Mills Sr wrote:
How exactly do I write to one of the tables to add a new record?

Use the CRecordset::AddNew() followed by CRecordset::Update().

Larry Mills Sr wrote:
Nowhere in the Wizzard supplied Recordset class is there an "Open(....)" statement...

See here.

While it does not do any updating, you might check out this[^] article.

Re: Why I cannot have a ListControl in a CRecordView derived class?

Larry Mills Sr4-Dec-09 13:52

Larry Mills Sr

4-Dec-09 13:52

David Crow wrote:
Make sure the DSN, the CDatabase object, and the CRecordset object are all opened correctly (i.e., non read-only).

David, that's what I'm trying to found out how to do!

All I've done since the the Wizard create the Recordset class is compile the program, which did so correctly. Am I supposed to do a database "Open(....) statement somewhere. I didn't see that in your I "Invoice" program anywhere.

I simply don't know what to do at this point.
Help please!

A C++ programming language novice, but striving to learn

Re: Why I cannot have a ListControl in a CRecordView derived class?

David Crow7-Dec-09 2:59

David Crow

7-Dec-09 2:59

Larry Mills Sr wrote:
David, that's what I'm trying to found out how to do!

Does the query contain any JOINs?

Larry Mills Sr wrote:
Am I supposed to do a database "Open(....) statement somewhere.

It's not necessary since CRecordset also has an Open() method.

Re: Why I cannot have a ListControl in a CRecordView derived class?

Larry Mills Sr7-Dec-09 5:13

Larry Mills Sr

7-Dec-09 5:13

David, I don't do any SQL statements. I'm supposing the recordset is initialized properly on execution. It does read fine(the data is in the varables. But it will NOT allow me to write a record to the database. I did this:
BOOL B = m_pSet->CanAppend(); and BOOL f = m_pSet->CanUpdate(); and both show "0" values.
I don't know how to make it "CRecordset::none" which is supposed to make it writable, but it doesn't. Another thing, in using Windows Explorer I right click on the folder and the "Read Only" box is filled in; I clear it and click the applly button, I select the apply to subfolders and files and click "OK" and no activity is shown I click "OK" and immediately click on property again and "Read Only" is again filled in. I go through the same thing again with the same results. I am the only User of this computer and all listed Users(ie, SYSTEM, Administrator, User all have "Full Control" security selected. What gives?

A C++ programming language novice, but striving to learn

Re: Why I cannot have a ListControl in a CRecordView derived class?

David Crow7-Dec-09 5:27

David Crow

7-Dec-09 5:27

Larry Mills Sr wrote:
David, I don't do any SQL statements.

In your CRecordset-dervied class, what does the GetDefaultSQL() method look like?

Are you using a DSN? If so, have you checked it for any "read only" properties?

Are you calling CDatabase::Open()? If so, what is the third argument being sent to it?

Re: Why I cannot have a ListControl in a CRecordView derived class?

Larry Mills Sr7-Dec-09 5:35

Larry Mills Sr

7-Dec-09 5:35

Here's the code:

CString CMyDB::GetDefaultConnect()
{
     return _T("DBQ=C:\\CookIt\\Program\\DataBases\\DB\\CookIt.mdb;DefaultDir=C:\\CookIt\\Program\\DataBases\\DB;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\\CookIt\\Program\\DataBases\\DB\\CookIt.mdb.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;");
}

CString CMyDB::GetDefaultSQL()
{
     return _T("[ApeData],[BreadData],[CakeData],[CandyData],[CookieData],[DrinkData],[FruitData],[MeatData],[PastryData],[PieData],[PudData],[Recipe],[SaladData],[SauceData],[SelRecipe],[SoupData],[Special2Pg1],[Special2Pg2],[Special2Pg3],[Special2Pg4],[Special2Pg5],[Special2Pg7],[SpecialPg1],[SpecialPg2],[SpecialPg3],[SpecialPg4],[SpecialPg5],[SpecialPg6],[SpecialPg7],[VegData]");
}

Here's some more code:

void CCookItDBView::OnInitialUpdate()
     {
     m_pSet = &GetDocument()->m_CookItDBSet;

     m_pSet->Open(CRecordset::dynaset,0,CRecordset::none );
     BOOL B = m_pSet->CanAppend();
     BOOL e = m_pSet->CanUpdate();
            }

Yes I am using DSN and no I don't use a CDatabase object(because I don't know how)

I don't know whaqt to put in the Cdatabase.Open(...,...,...) statement.
I checked carefully when I did the "add class" and OBDC dialog and the "Read Only" box was left unselected as was the "Execute" box

A C++ programming language novice, but striving to learn

Re: Why I cannot have a ListControl in a CRecordView derived class?

David Crow7-Dec-09 8:49

David Crow

7-Dec-09 8:49

Larry Mills Sr wrote:
CString CMyDB::GetDefaultConnect()
{
return _T("DBQ=C:\\CookIt\\Program\\DataBases\\DB\\CookIt.mdb;DefaultDir=C:\\CookIt\\Program\\DataBases\\DB;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\\CookIt\\Program\\DataBases\\DB\\CookIt.mdb.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;");
}

This looks odd. Mine always have the form:

return _T("ODBC;DSN=Gymnastics");

All of those other values (e.g., database, sizes) are defined in the DSN itself.

In my CDocument class, I have a CDatabase object. Anytime I need access to it, I use:

CDatabase *CMyDoc::GetDatabase( void )
{
    if (! m_rDatabase.IsOpen())
        m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=Gymnastics"));
  
    return (&m_rDatabase);
}

When I want to add to a table, I use:

CMyRecordset set;
set.m_pDatabase = GetDocument()->GetDatabase();
  
TRY
{
    set.Open();
    set.AddNew();
    ...
    set.Update();
    set.Close();
}
CATCH(CDBException, pDBException)
{
    AfxMessageBox(pDBException->m_strError);
}
END_CATCH

Re: Why I cannot have a ListControl in a CRecordView derived class?

Larry Mills Sr7-Dec-09 13:30

Larry Mills Sr

7-Dec-09 13:30

I copied that stuff from my program. That's the stuff the wizard produced. I am using VS2008 completely updated.
the MS Access database is called "CookIt.mdb" and with the DSN iit is now "CookIt.mdb.dsn" Is this normal? Now, you state you have a CDatabase in Documents. Do I declare it in the Header? and how do I get the CRecordset m_pSet set to that database? I may be asking this wrong.

The wizard created a CRecordset class called MyDB(I renamed it). How does the database you created in CMyDoc use the recordset that the wizard created?

You wrote: m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=Gymnastics"));

so if I used your code would mine be: m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=CookIt")); Is this right?

A C++ programming language novice, but striving to learn

Re: Why I cannot have a ListControl in a CRecordView derived class?

David Crow8-Dec-09 3:24

David Crow

8-Dec-09 3:24

Larry Mills Sr wrote:
the MS Access database is called "CookIt.mdb" and with the DSN iit is now "CookIt.mdb.dsn" Is this normal?

I don't think so.

Larry Mills Sr wrote:
Now, you state you have a CDatabase in Documents. Do I declare it in the Header?

Yes, just like you would any other member variable.

Larry Mills Sr wrote:
and how do I get the CRecordset m_pSet set to that database? I may be asking this wrong.

The constructor.

Larry Mills Sr wrote:

so if I used your code would mine be: m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=CookIt")); Is this right?

It looks right.

Re: Why I cannot have a ListControl in a CRecordView derived class? [modified]

Larry Mills Sr7-Dec-09 14:05

Larry Mills Sr

7-Dec-09 14:05

I used your code and it says:
m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=CookIt.mdb.dsn"));
"file not found"
if change it to:
m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=c:\\CookIt\\Program\\DataBases\\DB\\CookIt.mdb.dsn"));
and it gave error: "Data Source name toog long and not found"

I finally put the original under GetDefaultConnect(). Id gave an error of "ODBC does not support dynsets"
the database was created as 2003 and I used the driver 6.001 which is supposed to work on either dynasets or snapshots? any ideas?

I re-created the Recordset this time I selected "snapshot".
Now it says "Recordset is read Only"? I don;t understand this!

A C++ programming language novice, but striving to learn

modified on Monday, December 7, 2009 8:32 PM

Re: Why I cannot have a ListControl in a CRecordView derived class?

David Crow8-Dec-09 3:20

David Crow

8-Dec-09 3:20

Larry Mills Sr wrote:
m_rDatabase.Open(NULL, NULL, FALSE, _T("ODBC;DSN=CookIt.mdb.dsn"));

What name did you give the DSN when you created it?

You get there using either

Start --> Administrative Tools --> Data Sources (ODBC)

Or by typing odbccp32.cpl in the Run box.

Re: Why I cannot have a ListControl in a CRecordView derived class?

Larry Mills Sr8-Dec-09 4:12

Larry Mills Sr

8-Dec-09 4:12

At 9:00am CT I sent the files, including the db. Please acknowledge recieving it, sometimes I don't get notification that the mail sent failed.
Thanks

A C++ programming language novice, but striving to learn

Re: Why I cannot have a ListControl in a CRecordView derived class?

Larry Mills Sr9-Dec-09 4:25

Larry Mills Sr

9-Dec-09 4:25

So how do I update, delete, write to the database? Do I have to make a recordset for each table? That sounds very strange.

A C++ programming language novice, but striving to learn

Re: Why I cannot have a ListControl in a CRecordView derived class?

David Crow9-Dec-09 4:29

David Crow

9-Dec-09 4:29

Larry Mills Sr wrote:
Do I have to make a recordset for each table?

Yes, or you can do it via CDatabase::ExecuteSQL().

Re: Why I cannot have a ListControl in a CRecordView derived class?

Larry Mills Sr9-Dec-09 4:47

Larry Mills Sr

9-Dec-09 4:47

David,
What my intentions are, is that when the User creates a "Recipe" that I will write the record of that recipe to the database under the "Recipe" table. The [Recipe].[MealPlan] varable will tell me when loading the Recipe Meal Plan for viewing a User plan for a Meal(ie, Special Occassion Meal= Birthday Party, Wedding, etc. (see uploaded new "CookIt.mdb" db)
There is a Funtion in my program where the User selects ingredients and recipes they will use in developing a "Meal Plan" for a "Special Occassion Meal Plan". All Ingredients, upon User selections, are linked by the "MealPlanName", so that when the User selects a "MealPlan" from a list control that "MealPlan" is loaded. This works fine with my ".xml" database; I was trying to do the same thing with the MS Access DB. How would you go forth in accomplishing this with a MS Access DB?

I redid the CRecordset (dsn) to only include the "Recipe" table. It doesn't give any erros, it goes through the AddNew() and then at UpDate() it clears the fields and no record is written to the db.

A C++ programming language novice, but striving to learn

Message mapping

msr_codeproject29-Nov-09 6:56

msr_codeproject

29-Nov-09 6:56

Hi everybody,

What is the entry point for Message Mapping?

thid question was asked in some interview.

Thanks
msr

Re: Message mapping

«_Superman_»29-Nov-09 8:15

«_Superman_»

29-Nov-09 8:15

The interviewer was probably thing about the BEGIN_MESSAGE_MAP macro.

«_Superman_»
I love work. It gives me something to do between weekends.

Microsoft MVP (Visual C++)

Re: Message mapping

Rajesh R Subramanian29-Nov-09 8:18

Rajesh R Subramanian

29-Nov-09 8:18

msr_codeproject wrote:
What is the entry point for Message Mapping?

"Entry point"? Probably they wanted to ask about the class that is the base for message mapping architecture in MFC? In which case, it is CCmdTarget[^]

There are macros that might be of your interest:
DECLARE_MESSAGE_MAP[^]
BEGIN_MESSAGE_MAP[^] and
END_MESSAGE_MAP[^]

You might want to read on Message Handling and Mapping[^]

“Follow your bliss.” – Joseph Campbell

Dev C++ cant accept vector??

nuttynibbles29-Nov-09 5:10

nuttynibbles

29-Nov-09 5:10

Hi,
im using vector<string> strvector. it works in unix but when i run in Dev c++, it prompt me error like no matching function for call tp `Vector`.....etcc

why is this so??

Re: Dev C++ cant accept vector??

Rajesh R Subramanian29-Nov-09 5:19

Rajesh R Subramanian

29-Nov-09 5:19

1. Show your code.
2. Show the exact error message that the compiler issued.

“Follow your bliss.” – Joseph Campbell

Re: Dev C++ cant accept vector?? [modified]

nuttynibbles29-Nov-09 6:40

nuttynibbles

29-Nov-09 6:40

#include <vector>
using namespace std;

vector<string> vectorstr ;

....

vectorstr.push_back("....") 

...

for(int i=0;i<this->vectorstr.size(); i++){
			cout << "test:" << this->vectorstr.at(i) << endl;		
		}

...


void removeduplicates(vector<string>& vec){
  	sort(vec.begin(), vec.end());
    vec.erase(unique(vec.begin(), vec.end()), vec.end());    
  }

i have been getting error like:
implicit declaration of function int sort
implicit declaration of function int unique
no matching function for call to vector<basic_string....

<div="" class="ForumMod">modified on Sunday, November 29, 2009 12:55 PM

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