Why I cannot have a ListControl in a CRecordView derived class?
-
void CCookItDBView::OnInitialUpdate() { SetColumsIngred(); m_pSet = &GetDocument()->m_CookItDBSet; } ass you can see, I am calling it from the CRecordView class (see previous header code)
A C++ programming language novice, but striving to learn
Set a breakpoint in
OnInitialUpdateand single step intoSetColumsIngred.«_Superman_» I love work. It gives me something to do between weekends.
Microsoft MVP (Visual C++) -
Set a breakpoint in
OnInitialUpdateand single step intoSetColumsIngred.«_Superman_» I love work. It gives me something to do between weekends.
Microsoft MVP (Visual C++)I did that already. That's how I know where if crashes. I crashes on the three lines I indicated above.
A C++ programming language novice, but striving to learn
-
void CCookItDBView::OnInitialUpdate() { SetColumsIngred(); m_pSet = &GetDocument()->m_CookItDBSet; } ass you can see, I am calling it from the CRecordView class (see previous header code)
A C++ programming language novice, but striving to learn
Does the list control window exist at this point?
"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
-
Does the list control window exist at this point?
"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
Yes!
A C++ programming language novice, but striving to learn
-
Yes!
A C++ programming language novice, but striving to learn
So then what's the error?
"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
-
So then what's the error?
"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
David it doesn't give an error, it just crashes.
A C++ programming language novice, but striving to learn
-
David it doesn't give an error, it just crashes.
A C++ programming language novice, but striving to learn
Larry Mills Sr wrote:
...it just crashes.
Assertion, exception, what?
"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
-
Larry Mills Sr wrote:
...it just crashes.
Assertion, exception, what?
"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
//This crashes because as you indicated the window has not been created yet: void CCookItDBView::OnInitialUpdate() { m_pSet = &GetDocument()->m_CookItDBSet; SetColumsIngred(); CRecordView::OnInitialUpdate(); } // THIS IS CORRECT IT WORKS NOW void CCookItDBView::OnInitialUpdate() { m_pSet = &GetDocument()->m_CookItDBSet; CRecordView::OnInitialUpdate(); SetColumsIngred(); } I didn't understand you previous comment until in debug I caught it. Thanks David. Question: I have several "Tables" in the database that hopefully will point me to data contained in other tables that are not presently linked in the RecordSet. For example: Table "RecipeData" is not linked in the RecordSet (I didn't select it when I selected the Tables) can I still do this: CString str = m_pSet->[RecordDate].Recipe;
A C++ programming language novice, but striving to learn
-
//This crashes because as you indicated the window has not been created yet: void CCookItDBView::OnInitialUpdate() { m_pSet = &GetDocument()->m_CookItDBSet; SetColumsIngred(); CRecordView::OnInitialUpdate(); } // THIS IS CORRECT IT WORKS NOW void CCookItDBView::OnInitialUpdate() { m_pSet = &GetDocument()->m_CookItDBSet; CRecordView::OnInitialUpdate(); SetColumsIngred(); } I didn't understand you previous comment until in debug I caught it. Thanks David. Question: I have several "Tables" in the database that hopefully will point me to data contained in other tables that are not presently linked in the RecordSet. For example: Table "RecipeData" is not linked in the RecordSet (I didn't select it when I selected the Tables) can I still do this: CString str = m_pSet->[RecordDate].Recipe;
A C++ programming language novice, but striving to learn
Yes, you can reference whatever tables you want in the
GetDefaultSQL()method. Make sure that the fields in the query match the order of the associated variables in theDoFieldExchange()method."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
-
Yes, you can reference whatever tables you want in the
GetDefaultSQL()method. Make sure that the fields in the query match the order of the associated variables in theDoFieldExchange()method."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
David, I tried to write to the DB and I get an error "The RecordSet is read only." How do I change that?
A C++ programming language novice, but striving to learn
-
David, I tried to write to the DB and I get an error "The RecordSet is read only." How do I change that?
A C++ programming language novice, but striving to learn
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
-
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
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
-
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
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.
"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
-
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.
"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
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
-
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
Larry Mills Sr wrote:
...but I cannot write or delete any records in them
Make sure the DSN, the
CDatabaseobject, and theCRecordsetobject 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 byCRecordset::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.
"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
-
Larry Mills Sr wrote:
...but I cannot write or delete any records in them
Make sure the DSN, the
CDatabaseobject, and theCRecordsetobject 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 byCRecordset::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.
"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
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
-
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
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
CRecordsetalso has anOpen()method."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
-
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
CRecordsetalso has anOpen()method."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
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
-
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
Larry Mills Sr wrote:
David, I don't do any SQL statements.
In your
CRecordset-dervied class, what does theGetDefaultSQL()method look like? Are you using a DSN? If so, have you checked it for any "read only" properties? Are you callingCDatabase::Open()? If so, what is the third argument being sent to it?"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
-
Larry Mills Sr wrote:
David, I don't do any SQL statements.
In your
CRecordset-dervied class, what does theGetDefaultSQL()method look like? Are you using a DSN? If so, have you checked it for any "read only" properties? Are you callingCDatabase::Open()? If so, what is the third argument being sent to it?"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
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