We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

"Data Truncated" with Memo-field (CRecordset)

MelissaC
MelissaC asked
on
Medium Priority
559 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      
Comment
Watch Question

Author

Commented:
Adjusted points to 100

Author

Commented:
Adjusted points to 140

Commented:
What is the nMaxlength parameter of the RFX_Text-Call?


Author

Commented:
Adjusted points to 185

Author

Commented:
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!
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.