In MFC using a MS Access Database will NOT allow more Tahn 255 Chars even with setting RFX_Text to 1024 length
-
For code please see the below (Previous Post" (Previous post): <a href="http://www.codeproject.com/Messages/3303272/Re-Using-RFX\_Text\_Bulk.aspx">http://www.codeproject.com/Messages/3303272/Re-Using-RFX\_Text\_Bulk.aspx</a>[<a href="http://www.codeproject.com/Messages/3303272/Re-Using-RFX\_Text\_Bulk.aspx" target="_blank" title="New Window">^</a>] I cannot get the MS Access Database to accept over 1000 chars into a column using the RFX_Text that is set to 1024 length (See Previous Post CMyDB.cpp RXF listing). Does anyone know how to do this in MFC?
A C++ programming language novice, but striving to learn
-
For code please see the below (Previous Post" (Previous post): <a href="http://www.codeproject.com/Messages/3303272/Re-Using-RFX\_Text\_Bulk.aspx">http://www.codeproject.com/Messages/3303272/Re-Using-RFX\_Text\_Bulk.aspx</a>[<a href="http://www.codeproject.com/Messages/3303272/Re-Using-RFX\_Text\_Bulk.aspx" target="_blank" title="New Window">^</a>] I cannot get the MS Access Database to accept over 1000 chars into a column using the RFX_Text that is set to 1024 length (See Previous Post CMyDB.cpp RXF listing). Does anyone know how to do this in MFC?
A C++ programming language novice, but striving to learn
This may be a restriction posed by Access, i.e., the maximum length of a text field in Access is 255. If you want to store longer strings to a database field, you may need to look for something else, such as SQL Server. For smaller applications, you may use SQLite.
-
This may be a restriction posed by Access, i.e., the maximum length of a text field in Access is 255. If you want to store longer strings to a database field, you may need to look for something else, such as SQL Server. For smaller applications, you may use SQLite.
-
For code please see the below (Previous Post" (Previous post): <a href="http://www.codeproject.com/Messages/3303272/Re-Using-RFX\_Text\_Bulk.aspx">http://www.codeproject.com/Messages/3303272/Re-Using-RFX\_Text\_Bulk.aspx</a>[<a href="http://www.codeproject.com/Messages/3303272/Re-Using-RFX\_Text\_Bulk.aspx" target="_blank" title="New Window">^</a>] I cannot get the MS Access Database to accept over 1000 chars into a column using the RFX_Text that is set to 1024 length (See Previous Post CMyDB.cpp RXF listing). Does anyone know how to do this in MFC?
A C++ programming language novice, but striving to learn
Larry Mills Sr wrote:
I cannot get the MS Access Database to accept over 1000 chars into a column using the RFX_Text that is set to 1024 length (See Previous Post CMyDB.cpp RXF listing).
Unless the maximum was increased in Access 2007, the limit for Text fields is 255. With a memo field, you can store up to 65535 characters.
"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:
I cannot get the MS Access Database to accept over 1000 chars into a column using the RFX_Text that is set to 1024 length (See Previous Post CMyDB.cpp RXF listing).
Unless the maximum was increased in Access 2007, the limit for Text fields is 255. With a memo field, you can store up to 65535 characters.
"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
Yess, David, it is still 255. My field is set to Memo rather than text. but still it is NOT accepted by the Access DB; though eactly 918 chars was there before the Update() was called. long nMaxLength = 1024; RFX_Text(pFX, _T("[Instructions]"), m_Instructions,nMaxLength);// 918 chars loaded Less than 255 loaded into DB!!! I have no idea why this is happening. David A question nfor you personally: Was you ever able to setup the Edit() and Delete() functions in your program you sent me? Let me know if/when you have this. Thanks.
A C++ programming language novice, but striving to learn
-
longer data can be stored in binary format :confused:
Press F1 for help or google it. Greetings from Germany
But doesn't all the data fields(columns) have to be in binary? Could you please send me an example of how to do that.
A C++ programming language novice, but striving to learn
-
Yess, David, it is still 255. My field is set to Memo rather than text. but still it is NOT accepted by the Access DB; though eactly 918 chars was there before the Update() was called. long nMaxLength = 1024; RFX_Text(pFX, _T("[Instructions]"), m_Instructions,nMaxLength);// 918 chars loaded Less than 255 loaded into DB!!! I have no idea why this is happening. David A question nfor you personally: Was you ever able to setup the Edit() and Delete() functions in your program you sent me? Let me know if/when you have this. Thanks.
A C++ programming language novice, but striving to learn
Larry Mills Sr wrote:
David A question nfor you personally: Was you ever able to setup the Edit() and Delete() functions in your program you sent me? Let me know if/when you have this.
I've not forgotten. When I got back from my break, I had a bunch of Java/DBCS issues to resolve for our Japanese folks.
"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