?
Solved

"Data Truncated" with Memo-field (CRecordset)

Posted on 1998-09-07
6
Medium Priority
?
520 Views
Last Modified: 2013-11-20
Hi all,
I've got a problem reading data from an Microsoft Acess-table (office 97) with a memo field. I derived a class from CRecordset with a wizard and I pointed to the table, so the wizard could create member variables like this:

      long m_ID;            //unique ID, autonumber
      CString m_Label;      //Text field
      CString m_Text;            //Memo field

Whenever I do a MoveNext, the next record is read and the values are stored in the derived CRecordset-object, let's call it CMySet. The problem is: When the memofield exceeds a
certain number of characters (I don't know exactly how many, I don't like counting), I get a CDBException "Data Truncated".  But I read somewhere in the help that "A CString object can store up to INT_MAX (2,147,483,647) characters". Does anyone have experience with memofields?
Thanks in advance!
Melissa      
0
Comment
Question by:MelissaC
  • 4
  • 2
6 Comments
 
LVL 2

Author Comment

by:MelissaC
ID: 1321867
Adjusted points to 100
0
 
LVL 2

Author Comment

by:MelissaC
ID: 1321868
Adjusted points to 140
0
 
LVL 2

Expert Comment

by:connex
ID: 1321869
What is the nMaxlength parameter of the RFX_Text-Call?


0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 2

Author Comment

by:MelissaC
ID: 1321870
Adjusted points to 185
0
 
LVL 2

Author Comment

by:MelissaC
ID: 1321871
Thanks for the hint, connex. I found out the problem. It was in the RFX_Text call. If you propose the answer, I'll give you the points. Thanks!
0
 
LVL 2

Accepted Solution

by:
connex earned 540 total points
ID: 1321872
as wished .)

0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is to be the first in a series of articles demonstrating the development of a complete windows based application using the MFC classes.  I’ll try to keep each article focused on one (or a couple) of the tasks that one may meet.   Introductio…
Introduction: Load and Save to file, Document-View interaction inside the SDI. Continuing from the second article about sudoku.   Open the project in visual studio. From the class view select CSudokuDoc and double click to open the header …
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question